lookup wizard help

[Delta729]

Hello all,



I'm wondering if this is possible. I've been searching for a while, but haven't found anything.

I have a table that I'm using the lookup wizard on to pull names from another table to easily fill in this data. However, I'd like to be able to filter the list to only show active names. The table that the names are coming from have the options all set up for (1) Active, (2) Inactive. Is there a quick easy way to do this with the wizard or would this be done with a query?

Hopefully that makes sense. Any help would be greatly appreciated.

Thanks
Dan

[Delta729]

Never mind, I figured it out. Set it in the query. Duh.
SELECT tblRelationshipLead.[Relationship Lead], tblRelationshipLead.[RL Status] FROM tblRelationshipLead WHERE (((tblRelationshipLead.[RL Status])="(1) Active"));