how to close a form based on its text box value

A

alekmil

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
 
B

Brandon

Hello

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I check the current value of check box not reffering it by 4
Form size changing 0
Don't Close Form If... 2
Passing the value of ActiveControl to Unbound Text Box 1
Keep form open until loop completes 2
Set Focus to a null value in a continuous form 1
Close form w/o "can not contain a null value" 4
Check for empty fields 2

Top