limiting a field

  • Thread starter Thread starter unclezeb
  • Start date Start date
U

unclezeb

hi,
how can i limit a fiel to only allow pre set possibilities.
i.e. if i know that only 3 countries are possible, when in a form i ask
for country i want it to show only, i.e. sweden, norway, finland,
allowing the user to pick only among those 3.

sorry if this is really simple question.
I am greatful for any reply.

happy new year

unclezeb
 
I have to worry about Regions, instead of countries.
I have a tblRegions table that lists them all.
Click to expand...
I have one-to-many relationships between
Click to expand...
tblRegions.RegionID and all the other tables using the
RegionID, with enforced referential integrity.
I use ComboBoxes (instead of TextBoxes) on all my data
Click to expand...
entry forms. tblRegions is the record source for all the
ComboBoxes (easily done with a Wizard) and, by setting the
LimitToList property to 'Yes', the user can't enter a
Region not in the list.

Hope this helps!

Howard Brody
 
Back
Top