ACCESS DLOOKUP in a Query Criteria

[gheyman]

I have a table that has a Field named PID_Number and another named WBS_PG_ID. On a form a have a combobox where the user can select the PID_Number from that table.

I need a Query to where I want to put in a criteria. The criteria is the corresponding WBS_PG_ID for the PID_Number that was selected om the aforementioned form.

Can I put a Dlookup in the Criteria? Or do I need to do the Dlookup elsewhere and use that result in the Criteria?

 

[gheyman]

No longer have a question. Decided to go another way