Prompt for Default Value

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

default value based on an expression within the table 2
Default Data in table view 4
default value or prompt for value in a report 4
Default Value in Table 2
Table default value question 2
Adding default value to pre-existing table 2
Default value problem 4
TempVars unusable in field default value 10

Back
Top