By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Drop Down List in Access 97

P: 1
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
Jul 28 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
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
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.