Hello,
I am currently trying to create a search button/box to find specific records in a report. The report is a nutritional table and has the textbox "item number" on it. I want a search button/box to search through the "item number" text box that is laid on top on the report.
I have very little knowledge on Access. I know how to create text boxes, command buttons, combo boxes, ect. I do not know how to write code, but the internet has taught me a thing or two about stringing together code.
What I want to happen:
- Type item number in text box
- Click command button
- Command button searches records that match the "item number" in the search textbox.
- Report opens at print preview screen with found-matching record
Any help/advice is appreciated.