Adding a field to a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emanuel.levy@gmail.com - 06 Feb 2006 19:19 GMT

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";"Unassigned"

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

Reply to this Message

inkman04 - 07 Feb 2006 00:01 GMT

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:Unassigned (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.

Reply to this Message