View Full Version : Using Forms in a query


cincibcats
10-26-2000, 12:56 PM
I have a table that contains a list of Job numbers. I would like to use a combo box to input the selected job number into a query. It would be like a criteria "FROM [Forms]![Get a Receipt]![Job ID]" however that doesn't work

chrismcbride
10-26-2000, 05:12 PM
Perhaps this an over-simplification but, I thnk that all you need is to put...
=[Forms]![Get A Receipt]![Job ID]
...in the Criteria line of the JobID field of the Query. This should be all you need to do.
Chris