Find a record from a drop down box

[Bill Mills]

I have a form that is filtered by the region of the person
logging in. So if a person logs into an application is
from the NE region, the form will only display those
records from the NE region. The question I have is that I
want to have a drop down combo box that when you select a
record from it, it will go to that record and display it
on the form. That is easy to do, however the catch is
only populating that box with only the records from that
region in which the form is filtered. Any ideas would be
greatly appreciated?

 

[Larry Linson]

How do you determine, as you have set up your application, how the Form is
"filtered", and, is it really "filtered" or does it just limit the records
displayed with criteria in the report's recordsource or a WhereCondition in
the DoCmd.OpenReport. There is likely a way to do what you want, but it
would be different in each of these cases.

Larry Linson
Microsoft Access MVP