Limiting Contents of a Combo Box

A

albertoc1972

I have a form on which individuals can enter new sites. One of the criterias
of each of the sites is the region in which it is located. Each region is
either "open for editing" or "closed for editing." I want to make it so that
in the combo box that they use to choose regions, the only regions that
appear are the ones that are "open for editing." How do I do this?

I have three tables:
Regions
Sites
Details which map the Site ID to the region plus a whole host of other
information/tables.

Thanks.
 
G

George Nicholson

If it were me I'd create & save a query that simply showed regions open for
editing (qcboRegionsOpen). Then use that as the RowSource for my combo.
Odds are you'll find a use for that query again somewhere down the road.

HTH,
 
A

albertoc1972

Great. It worked nicely.



George Nicholson said:
If it were me I'd create & save a query that simply showed regions open for
editing (qcboRegionsOpen). Then use that as the RowSource for my combo.
Odds are you'll find a use for that query again somewhere down the road.

HTH,
Click to expand...
 
Top