how to close a form based on its text box value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
is there any way I can Close form "X" from its OnCurrent Event procedure ie. how can I close for
from that form's procedure.
In other words, I want to wait for form to be filled by underlaying sql, than to check if the
certain field is null and if it is null to close form
I could execute additional sql before I open form ( and check if the value is null for tha
specific field) but I want to know if there is way to skip tha
additional sql executing
Hope I'm not too confusing

Than

Alekmil
 
Hello

In the OnCurrent procedure, check the value of the text box

if isnull(txtbox) the
docmd.close, acform "formname
els
cod
end i
 
Back
Top