limiting a field


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
 
Ad

Advertisements

H

Howard Brody

I have to worry about Regions, instead of countries.
I have a tblRegions table that lists them all.
I have one-to-many relationships between
tblRegions.RegionID and all the other tables using the
RegionID, with enforced referential integrity.
I use ComboBoxes (instead of TextBoxes) on all my data
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
-----Original Message-----

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


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top