Access Seach Box in MSAccess Using Wildcard

A

abaxt

Joined
Jun 8, 2005
Messages
5
Reaction score
0
Hi,
I am very new to programming and have only just got started so please bear with me if this is a really basic question.

I have a form which updates a table, and I would like the user to be able to key in a keyword and a list to be displayed of all the Item Descriptions which have this keyword included in them.

I understand I need a Wildcard but I am not sure how to link this on my form.
Currently I have a text box where the keyword is keyed in and a combo box which displays all the Item Codes and Item Descriptions.

Can anyone help by pointing me in the right direction ???
Many thanks
Angie
 
You need to create a select query from the table your are accessing. The form is then attached to this query. Place the following into the field criteria of the search: Like "*" + [Part of Descriptor] + "*"
This will prompt for the input using a message box. There is no need to add anything to the form other than have it retrieve the result of the query.
Cheers
N.
 
Back
Top