Adding a new record from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm building a form where the user would first enter their location, and then
would enter several records. What I'm having a hard time figuring out is how
to have the location that the user enters also become part of the
record...ie, I don't want the user to have to enter their location for every
record they add. I just want them to enter it one time at the top of the
form and then they can just add their new records without retyping the
location every time. I can get the record to be added, but I can't get the
location field to be filled in on the new record.

Any suggestions on how to make this work?
 
I've done this in the past using something like
DLookup(table,userID,condition) as the default user ID value on the form and
the condition being Dmax(table,Id)-1. This assumes that you have an auto
incrament record ID. The person only has to enter the ID on the first record.
 
Back
Top