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

  • Thread starter Thread starter Davie
  • Start date Start date
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?
 
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
 
Back
Top