Hi I’m new to this forum and fairly new to access have decided to try and teach my self-using books and internet I have found your forum very useful so far but am having trouble writing a SearchForRecord macro. I have a search box on the Data Input Form which I want to enter a value which then searches a Field called Production Order Number on the same form below is an image of my database and the string in where condition. Any help would be appreciated
SearchForRecord macro
- Thread starter Yen 1
- Start date
Trevor G
Registered User.
- Local time
- Today, 01:14
- Joined
- Oct 1, 2009
- Messages
- 2,368
Welcome to the forum, you can do the following. Open your form in design view then add the command button wizard and select find record then step through the rest of the questions this will give you a button and the code is behind it.
You can add to the code so it always searches your field or you just click the field and click the button.
You can add to the code so it always searches your field or you just click the field and click the button.
