Using Set Value in Multiple Forms

  • Thread starter Thread starter Balfour211
  • Start date Start date
B

Balfour211

I am currently using Access 2003. I have a couple of different forms that
have a Date Field in them. I want to be able to double click on the date
field, and get it to automatically enter the current date. I had trouble
doing this with Code, so I used the Set Value command in a macro.

My question is, Can you use the same Macro on the different forms, or do you
need to create a different Macro for each form. So far the only way I see to
do it is to create multiple Macros. Any help would be appreciated.

Thanks,
Balfour211
 
Balfour,

No, you can use the same macro for multiple uses.

However, are you aware that Access provides a specific keyboard shortcut for
exactly what you are doing?
Ctrl+;
(i.e. press Ctrl key and semi-colon key at once.)
 
Thanks for your help and suggestions. The only problem is the people that I
am builing this for will not remember the keyboard shortcut. How do you use
the same Macro for this task on different forms when you are required to name
the form where you want the action to take place. If I am using the macro on
two different forms, and only one of them is open at any given time, when I
run the Macro, I get an error when Access can't find the form that is not
open.
 
Never mind. I found an example and figured out how to apply it to my
program.

Access - The more I learn, the more I realize how little I know.
Balfour211
 
Balfour,

Sorry for the delay in getting back to you. But happy to know that you have
it sorted now.
 
Back
Top