Hide data before Searching

[cenderawasih]

Hello....

I have a continuous form that contains 2 comboboxes. User will select the job number and subjob Id from this combobox then when they click FIND button, The list of jobs and subjobs will be filtered to match the one specified in the comboboxes.

The find function works fine....what i need now is for the form to hide the lists of jobs before button FIND is clicked...meaning...when the user enter the form for the 1st time, they can only sees two blanks comboboxes and the FIND button...without the list of all jobs that exist in the database.

can anyone help?

 

[JeremyNYC]

Well, it all depends on how you're putting the data into the subform. If you're using the filter property, just make the default filter, the one that gets saved in form design view, be 1 = 2. That will ensure that no records are retrieved.

If you're dynamically setting the sql behind the subform, just make the default rowsource include that same criterion: WHERE 1 = 2

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[cenderawasih]

Thanks Jeremy...U really helped......