Adding Data Field

J

John Calder

Hi

I run Win2K with Access 2K. I have a database that requires another column
in the sheet. This I can do, but I want to add a combo box to my form to
accomodate the data that the new column will take. This I can do also, what I
dont know how to do is how do I link the data from the new column I have
added to the combo box that I have added to the form?

Any help is much appreciated.

Thanks
 
S

Steve Schapel

John,

Lok at the Properties of the Combobox. The Control Source property is
the name of the field in the form's underlying table or query that the
data in the combobox relates to. The Row Source property defines where
the combobox gets the values shown in the combobox's drop-down list.
This is usually a table or query, although you can also define a "value
list". If you want the combobox's drop-down list to show more than one
column, there are other properties that you will need ot attend to as
well, i.e. Column Count, Bound Column, Column Widths.

If you still need more help with this, please post bach with more
details and specific examples.
 
J

John Calder

Thanks a lot Steve

Steve Schapel said:
John,

Lok at the Properties of the Combobox. The Control Source property is
the name of the field in the form's underlying table or query that the
data in the combobox relates to. The Row Source property defines where
the combobox gets the values shown in the combobox's drop-down list.
This is usually a table or query, although you can also define a "value
list". If you want the combobox's drop-down list to show more than one
column, there are other properties that you will need ot attend to as
well, i.e. Column Count, Bound Column, Column Widths.

If you still need more help with this, please post bach with more
details and specific examples.
Click to expand...
 
Top