Drop Down List in Access 97

[Grimason-NZ]

Hi,
I have MS Office Pro 97 and have built a database that has two tables.
The MS Office Pro 97 manual does not appear to cover how to make a Drop down list and thus I need some advice on the how to.
The drop down list boxes will be in the subform.
The values that I would like to show in the second table which is what the subform is designed on are;
List 1 values: Approved Discharge, Denied, Not Discharging
List 2 values: Low Risk, High Risk

TIA,
David

[PEB]

Hi,
I have MS Office Pro 97 and have built a database that has two tables.
The MS Office Pro 97 manual does not appear to cover how to make a Drop down list and thus I need some advice on the how to.
The drop down list boxes will be in the subform.
The values that I would like to show in the second table which is what the subform is designed on are;
List 1 values: Approved Discharge, Denied, Not Discharging
List 2 values: Low Risk, High Risk

TIA,
David

Choose list control box and put it where you want...
than for the first list in the record source property in the property window pres the ... bouton and convoque the query builder...

Choose your Table2
Select with double click your fields for the list

Close the builder and see the properties:
ColumnNumber: Type the column numbers of your list
See columnWidth with this property you can modify the vision of your columns on the screen

Listh with usually is the sum of column width By default it is set to auto...

And so your list is created Do the some for the next list :)

Best Regards

Vladimir