How do add a drop-down list of 'subject's studied in Access 2007?

D

Davie

I want to enter data of start/finish time when studying different subjects so
I need to add a selection of subject via a 'drop-down list'. Can you help me
please?
 
W

Wayne-I-M

Hi

Add a new combo box to your form. Open the properties box and select
Table/Query from Row Source Type dropdown.

In the row souce put this

SELECT [TableName].[ID], [TableName].[Subject] FROM [TableName];

Set the column sizes to 0;2.5
Bound column set to = 1

Of course change the TableName and Subject to the names they are in your
application

Good luck
 
Top