Re: ComboBox Properties

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ed (anonymous_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 14:51:45 -0400

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

"jilleo" <jill@armorsecurity.com> wrote in message
news:96b1588c59fe0789b4748e6737ca315a@localhost.talkaboutsoftware.com...
> 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
>
>