RE: Adding a new record from a form

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.

"scorpiorc" wrote:

> 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?
>
>
.

Quantcast