Drop-down boxes

[Sarah]

I want certain fields to have drop-down boxes:
a) Drop downs that pull fields from another table
b) Drop downs that include categories I manually input into the design
of that field (i.e., not tied to another table, but they must be selections
from a predetermined list)

I think this should be fairly easy. . .any suggestions?

 

[Golfinray]

Listboxes or combo boxes should do the trick. Let the wizard make those for
you that you want bound to a table or query. For unbound, you will probably
have to add the controlsource or formula you need.

 

[fredg]

I want certain fields to have drop-down boxes:
a) Drop downs that pull fields from another table
b) Drop downs that include categories I manually input into the design
of that field (i.e., not tied to another table, but they must be selections
from a predetermined list)

I think this should be fairly easy. . .any suggestions?

Add the combo box to your form using the Combo Box Wizard.
If you follow the wizard's instructions you can load the combo box
rowsource with both a and b type values.