Prompt for Default Value

R

Rob

Is it possible to have the default value of a field be dynamically set via
prompting the user to choose from a selection of values that are listed
within another table?


Thanks in Advance,
Rob
 
P

Pat Hartman

This is what you would use a combobox for. Create a query that lists the
options and use that as the RowSource for a combo. If you choose the
LimitToList option for the combo, the user will only be able to select items
from your list. No prompting is necessary, nor is any code necessary.
 
J

Jeff Boyce

Rob

As Pat points out, you can use a combobox to do this.

By the way, a bit of terminology... a "default" value is a (single) value
that will be used unless some other value is entered. What you are
describing (and Pat points out how to) is considered a "lookup". Not a
lookup field in a table, but using a combobox on a form to perform a lookup
from a "lookup table".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top