User defined default values for form fields?

J

Jessi

I would like to create a form used to input data into a table. The table
structure is shown below:

tbl:Mass1_Rock
StationID (fk)
SampleID (pk)
Mass1
Personnel (fk)
Comments

When the user enters data into the form, they will be entering data for one
station and personnel at a time. Stated another way, they will be entering
all of the mass data for station "6" that was measured by personnel "Dave" at
one time.

In the form I could set the default value for StationID to "6" and the
default value for personnel to "Dave". However, I was wondering if there is
a way to create a dialog box that pops up when the form loads where the user
can choose the default values from the StationID and the Personnel fields
each time they open the form to input data.

I probably haven't stated this question very well, but I'm not certain what
the correct terminology is for what I'm asking.

Regards,
 
J

Jessi

Thanks! I came across this in some of my searching, but I didn't really get
it until I read your response. This is what I need. Thanks for sending
along an example of the code too.

Jessi
 

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

Top