Search a post in Access

I have created a form containing textboxes for all fields in the table "Hotel", i have added a textbox that you can type a certain text and then a search button aswell, when you press this button it should find this value in Hotel.Hotel and if it does it will jump to that post, if it doesnt nothing should happen. Maybe you check the recordset if you have found a value and then you reload the form with a specific argument??
Who is Participating?
jjafferrConnect With a Mentor Commented:
Hi illion,

Make a query based on your Hotel Table, call it qrySearch,
in the query, make a field
AllTextBoxes: Textbox1 & Textbox2 & ... type all your Textboxes you want to search,
in the criteria write:
like "*" & Forms![YourFormName]![YourSearchFieldName] & "*"

Make a Tabular Form call it frmSearch based on qrySearch,

In your Original Form where you type the Search item, make a command button,
follow the wizard to open frmSearch.

How it works:
When you type an item for Searching and press the command button,
It will open frmSearch, which will take its values from qrySearch,
qrySearch will take the Search criteria from YourSearchFieldName,
the results of qrySearch will be displayed on frmSearch.

Hope this helps

Thanks for the points and the grade
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.