nathan2314
12-11-2008, 02:56 PM
:hi::hi:
Hi All,
I have a form set up and would like to include several combo boxes to uses for searches on the data. I've been able to figure out out to use the wizard to create combo boxes to find a record in the data but this is not what I'm looking to do. I'd like to have several drop downs so that I can have a person search on things like name, city, state, or none of these or multiple of these. So far, using the wizard to set up search combo boxes it just finds one record then I can still use the navigation buttons at the bottom to move to the next record in the data even though the next record doesn't meet the critieria. Also, on the search combo boxes the wizard creates, it doesn't allow me to have a blank option in the drop down so I can select not to search by the criteria.
Whats the best way to set this up?
Appreciate any help!!:yes
Hi All,
I have a form set up and would like to include several combo boxes to uses for searches on the data. I've been able to figure out out to use the wizard to create combo boxes to find a record in the data but this is not what I'm looking to do. I'd like to have several drop downs so that I can have a person search on things like name, city, state, or none of these or multiple of these. So far, using the wizard to set up search combo boxes it just finds one record then I can still use the navigation buttons at the bottom to move to the next record in the data even though the next record doesn't meet the critieria. Also, on the search combo boxes the wizard creates, it doesn't allow me to have a blank option in the drop down so I can select not to search by the criteria.
Whats the best way to set this up?
Appreciate any help!!:yes