ComboBox Properties

[jilleo]

Hello-

I keep wanting to put combo boxes on my forms. The combobox looks up data
from a table. The table contains a simple ID and Description. I would
like the description to display on the form, but I would like the ID to be
the stored value in my underlying table.

This is something that can be accomplished with Data Access Pages because
there are properties for ControlSourceproperty, ListRowSource property,
ListBoundField property and ListDisplayField property.

These properties don't seem to exist in forms. Any ideas on this? I can
think of ways to do this with 2 seperate fields, but that looks messy and
inefficient.

Thanks.

Jilleo

 

[Ed]

Set in the format tab:
- column width to 0";1"
- column count to 2
Set in the data tab:
- Row Source Type to Table/Query
- Row Source to 'Your table or query of 2 or more columns with ID as the
first column'
- Bound Column to 1

ed