Search Criteria

[Dazzla]

This may be simple but im new to access. Is there a way for me to only open a form(from a button) if a value from one of the fields in the form to be opened is set to "open"? I know this could be done through a query, but is there any VB that could do the same job.

 

[Oldsoftboss]

I would go about it like this:

Set the enabled property of your cmdButton to false so when the form is opened the button will be disabled. Then, in the afterupdate event of your textbox put code like:

If Me.textbox = "whatever" then
Me.cmdbutton.Enabled = True
Else
Me.cmdButton.Enabled = False
End If

Dave