combo box

[Guest]

I have a combo box for client id's which I restrict based on who the broker
is using a query. Only problem is when the form opens it gives the first
client even if it doesn't belong to that broker.

I want the first client for that particular broker to show when the form
opens.

I've tried doing a requery of the combo box on open, and load but this
doesn't help.

 

[Guest]

Never mind I figured it out. I made the form select only clients for the
broker.