GEt started on data lookup

[dalex17]

Hello,

I have a very simple database with one table, and a form that feeds of the columns of that one table.

I am trying to create a customer satisfaction log and would like to learn how I can create a lookup query on the form.

For example, if I wanted to reference a record but do not have any information except a piece of the subject matter of the record (i.e mismatch issue, customer from Idaho, etc...), I want to build a query where a user can enter a couple of words and have Access list the relevant records.

I'm not looking for a detailed solution, but more of a finger in the right direction.

Thanks,

Dalex

 

[GoDawgs]

Just a basic overview of this:

You're going to have to build your SQL in code I believe...basically you'll need to use the LIKE statement and some *'s around your text box. Something like this:

"SELECT...WHERE [field] LIKE *" & me.txtwhatever & "*"

Hope that gets you started, let me know if you need some more help.

Kevin

 

[dalex17]

Thanks godawags.

May I ask that you give me a more detail sample on how to do this?

let's say that the fields I want to search through are: 'description','description cont','resolution', and 'resolution cont'.

The word I want to lookup is "mismatch"

Also, should I bring a new text box into the form and use it for the word lookup (i.e. mismatch)?

Thank you,

Dalex