Hello everyone. It has been a while since I posted in dbforums. Hope all is fine and OK guys. Question please.
I have a form purpose of which is to search by name. It has a subform to which a query is attached. The query has a field named "Name" to which this expression is placed in the criteria:
Like "*" & [Forms]![frm_verification_check (name)]![name_x] & "*" And <>"Cancelled"
[name_x] is the textbox on the form in which I input the name to search. My question is if it is possible to prevent the query of the subform from running whenever I open the form 'coz it takes some time for the form to load. I would rather the query run when I actually put the name in the textbox.
Is there a way to prevent a form from requerying? Thanks a lot guys!
Thanks for the reply pootle flump! However, I never really used access' code builder on an advanced level, so I hope you can fill in the blanks for me.
The name of the form is 'frm_search_name' and the name of the subform that shows the data is 'sf_search_name'. How do I actually insert the code? I was trying to fill in the blanks but it didn't work. I was trying to insert it as an event procedure in the On Open property of the subform.