Using Forms in a query

cincibcats · Oct 26, 2000

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 · Oct 27, 2000

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

Using Forms in a query

cincibcats

Guest

chrismcbride

Registered User.

Similar threads

Users who are viewing this thread