I need to look up fiels using Combo list entry

[AliAmanAmarAdel]

I have a tracking system db with many tables.
In setting my adding new job form I came to pause.
In my requirements I need to be able to fill the history of a job given few fields.
I know I need a query , but when can I implement the sql statement.
could use any help [sig][/sig]

 

[kathryn]

Generally, if you are using a form to create a query, you use a command button. The Click event of the command button will pull values from your form to build the SQL statement, which you can then execute.

For example, if your fields on a form are Name and Address

dim strSQL as string

strSQL = "SELECT * from tblMyTable WHERE name = '" & me!name & "' and address = '" & me!address & "'"

I'm not sure this is what you are looking for, but I hope it helps. [sig]<p>Kathryn<br><a href=mailto: > </a><br><a href= > </a><br> [/sig]