Forum Discussion
Access - Template Contacts - "Search Not Picking Up words"
Hello, first time using Access. I was looking online for what is a good(free) program for our office contacts. We have clients, trades, supplies, designer, contractors, etc. so I came across Access! ...
Hello Claire,
You need to add the following to the Search-macro, since you added the Project-field to the Contacts-table and the Contact List-form (Right click the Search-macro and select Design View to edit the macro) :
After adding the statement to the macro and saving it, the Search-functionality in the Contact List-form also searches in the Project-field.
Good luck.
Best regards,
Tieme
- Hi Tieme,
Thank you for your response.
When I'm in the Design View - how do I get to the edit the marco?- Hello Claire,
At the bottom of the macro you can add a new action and select the SetTempVar -statement. After filling the statement-parameters for Project (as in the example) you can move it up with the green up-arrow.
Alternatively, you can select the last SetTempVar-statement, right click on it and choose Copy. Next right click again and choose Paste. Now fill in this pasted-stament the reference to the Project field.
