Search Form Help!

[vividor]

I have a table and a form name "BSA Report Form" to enter the data.

I would like to create a search form with 3 text box fields (Quarter, Location and Business Unit) in order to get a specific record.

I want to do that because the users are managers that sometimes do not have time to complete the report the same day so they have to comeback to finish it. By doing a search form, they will be able to comeback and complete the report.

How can I do that? any suggestions?

 

[Tay]

I've found that cascading combos have proved the most useful, especially as it means the user doesn't have to type anything in. That way you can choose 'quarter' from a the first combo, it is linked to the second, so only those related 'locations' will appear and this in turn can be linked to your third combo. So when you have chosen your location, only the relevant 'business units' come up. Then you can have a button which will take you to your main form at the correct record.
Do a search on these forums on 'cascading combos' and you should find something useful.

 

[vividor]

TO be honest, I tried to make a Search Form base on a query before but it did not work for me..
I think I am not doing something right, can some one explaing to me How to do that search form.