Using Forms in a query

  • Thread starter Thread starter cincibcats
  • Start date Start date
C

cincibcats

Guest
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
 
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
 

Users who are viewing this thread

Back
Top Bottom