Adding a field to a Form

[emanuel.levy@gmail.com]

I have an Access Database that I was given to modify. I am trying to
add a Combo Box with the following choices

Yes
No
Unassigned.

I went into the Table and added an entry called

Trained

It is a data type of Text with the following properties

Display Control:Combo Box
Row Source Type:Value List
Row Source "Yes";"No";"Una ssigned"

To add the form I'm doing New Combo Box then choosing I want the combo
box to look up the values in a table or Query then I pick the table
that I added the entry to but it is not there

[inkman04]

Re: Adding a field to a Form

Hello,

First, make sure the source table and/or query for the form
has a field to hold the information for yes,no or unassigned.

Can be a text field for inputting the words "Yes"; "No" or
"Unassigned ".
Or, it can be a number field to hold the ID assigned to
each of the words from your Value list.

Then, from the tool box, add a combo box to the form the way
you described above and select the "New" field from the table
or query that is the source for your form.

Example: 1:Yes;2:No;3:Un assigned (Colon between 1 & Yes,
and a semi-Colon between the group.)
Then, set the column count to 2 and Column Widths = 0;.5
This set up hides the "ID" number for each selection and displays
the choices you want.

Hope this gives more choices than what were there.

Regards.