Hello,

I have a broker form and a dealership subform that I need to create lookup combo boxes for. I creatd the combo box for the broker form with no problem, but I am having problems creating the lookup combo box for the dealership subform and have the combo box only bring up dealership records that are related to the broker form.

The combo box is showing all dealership records and I would like to limit the combo box to just show dealership records related to the particular broker.

Any ideas?

Need to reference the form field with the BrokerID in the WHERE portion of the SQL query. Something like:

SELECT DealerName
FROM tblDealers
WHERE (((tblDealers.BrokerID)=Me![BrokerID]))