Form Linked to Table w/Set Choices

[Guest]

I have a form that has a text box linked to a table with approx 100 records.
It has a four predetermined choices.

Problem is the link only gives me the actual records for selection and not
the predetermined choices.

TIA

 

[Steve Schapel]

Earl,

Can you give a bit more information here, maybe with an example. Are we
talking about a combobox here, rather than a textbox?

 

[Guest]

Steve:

It is actually a combo box currently.

The form is used for data entry for permits issued.

We track the permits as Active/Withrawn/Revoked/Expired. At the point of
entering the initial data I want the same selection that are in the tables.

 

[Steve Schapel]

Earl,

The list of options available in the list of a combobox is controlled by
the combobox's Row Source property. You can either use a table or query
that gives a list of the values required, and enter the name of the
table or query in the Row Source property of the combobox. Or you can
set the combobox's Row Source Type property to Value List, and then
enter the items you want in the combobox list direstly into the Row
Source property, separated by ;s.