Storing a value for later use in vba or a Macro

  • Thread starter Thread starter Jack G
  • Start date Start date
J

Jack G

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
 
Sorry--I posted this question to the wrong group. It's really an Access
question.

Jack
 
Back
Top