Search for a record on a form

CoddFish

Registered User.
Local time
Today, 03:05
Joined
May 26, 2003
Messages
36
My objective is to have an easy way for a user to get to the record that they need to edit/delete (on a form) quickly, without having to sroll through every record to get there. I want the user to have a way of selecting (or typing in) data in a combo box from the available records in a recordset. It would be nice if there were a way to have a multiparameter query underlying the form so that all the user has to do is select from whatever field he/she would like to search on to find the record. I know you can do this by basing the form on a query -- I just hate the default pop-up box -- rather than a series of pop-up text boxes asking the user to type in data for each parameter, I would like a way to display one pop-up box with all of the parameter fields displayed as combo boxes with all of the possible choices in a given recordset displayed in each pull-down list.

Any ideas?

Thanks.

-CoddFish:confused:
 
Thanks!

Thanks for the reply Jack! I'll let you know how it goes...

-CoddFish
 
Hi

The attahed sample db may be what you are looking for. It has those features you mentioned.

You will need to modify it to suit your application.

Anyway, here goes

Cheers!!!!!!



Lou :cool:
 

Attachments

Users who are viewing this thread

Back
Top Bottom