Having a Combo-box displaying data from a field in a table

[LMcleod]

Hi,

I'm quite new to using forms in Access. I want to create a drop-down list in my form which has the data from a specific field in a specific table. I have made a combo box, but I don't know how to link it to the table. Any ideas??

Louise

 

[hymn]

Have Form in design view
right click on Combo box
goto
Properties
Row Source = Select field From table

hope this helps

 

[welshone]

right click on the combo box and then properties.

click on the Data tab.
you need to change the row source to the query or table you want to display in that combo box.
change the Bound Column to the field where the dat you wish to store is, ( ie, ID )

Click on the Format tab,

change the column count to the number of columns you wish to display in the combo box from your table or query.

change the column widths to hide or show certai columns, ie:

fields frm table:
ID
Name
DOB
Postcode

column count 4,
column widths :
0cm;4cm;0cm;3cm

will show:

Name , Postcode

in the combo box.

good luck.

 

[LMcleod]

Thank you both for your help - welshone, I needed the detail - I'd have been lost without it!