Sorry--I posted this question to the wrong group. It's really an Access
question.

Jack

"Jack G" wrote in message
...
I think this must be a very basic and simple question, but I'm stumped: How
do you programmatically store a value from one record to use in another
record? For example, say I have a form displayed which has a customer name
field in it with the name 'Joe Smith'. If I press a button for 'New Record
with Same Customer', I'd like Access to remember that name and fill it in
on the new record with a macro or vba procedure. I don't know if I have to
store Joe Smith on a form or a table somewhere, or if I can just define a
variable.

And a related question is: How could I store the most recently viewed
record and then have Access automatically start at that same record the
next time I open it?

Thanks for any guidance.

Jack