Search Form

[icaines]

I am trying to create a search form containing over ten different fields from a table as search criteria. The goal is to allow the user to enter search information in one or more fields as search criteria with the ability to leave the other fields blank if necessary.

Originally I tried doing this through a Query but I know this way is not ideal for what I'm trying to to do. I believe the answer is through code but I have no idea on how to go about it. I am not an expert when it comes to Access, so any help would certainly be appreciated.

Thanks!

 

[Ranman256]

thats a lot of work when you can just give the user a query grid and let them enter it.

 

[icaines]

I've never heard of that option. Can you give me more info. on how I could do that?

 

[sxschech]

He may have been suggesting that the user edits the query directly in design view.

 

[sxschech]

Form would depend on how you want users to enter criteria, will they be choosing a specific item for each field or do they need to select more than one and would you allow wild cards to determine the use of combo box, list box, textbox. Then you would need to have a button to run the query which would build the sql statement based on the values clicked or typed into the boxes.

 

[icaines]

Well if possible I would like the user to select multiple items from a combo box, and type info into several text boxes with the ability to leave some fields blank, but I'm not sure if this is possible. Any guidance on how to do this?

 

[sxschech]

Multi selections will require a list box and you will need some vba code to make it work.

 

[jdraw]

see this thread for more info multifield search

Good luck.