D
doug
You want a Validation List. Go to DATA, VALIDATION in the
Menu. In the Data Validation dialog, go to "Allow" window
and select "List." In the "Source" window, select a range
outside the print range of your form or report. Click
OK. You will need to go to that selected range and enter
your predetermined values; these values will appear in the
Drop-down list. It works best if you enter your list
values in Row 1 to the far right of your form/report--out
of the way, then hide Row 1 after you're done. Adjust
your Source Range as needed to include the entire list
range in Row 1. The Input Tab is where you enter a User
Prompt that appears when the User's cursor lands on the
target cell. The Error Tab is used to type the Error
message that will appear if the user tries to enter a
value outside your list range.
Menu. In the Data Validation dialog, go to "Allow" window
and select "List." In the "Source" window, select a range
outside the print range of your form or report. Click
OK. You will need to go to that selected range and enter
your predetermined values; these values will appear in the
Drop-down list. It works best if you enter your list
values in Row 1 to the far right of your form/report--out
of the way, then hide Row 1 after you're done. Adjust
your Source Range as needed to include the entire list
range in Row 1. The Input Tab is where you enter a User
Prompt that appears when the User's cursor lands on the
target cell. The Error Tab is used to type the Error
message that will appear if the user tries to enter a
value outside your list range.