Run MacroOnce Daily on Form Open

[AccessIM]

I have created a macro that will run three separate append queries and want
it to run when a specific form is opened. To avoid duplicates, I only want
this macro to run the first time the form is opened.

Is there a way to limit the number of times to one regardles of the number
of times the form is opened?

Thank you in advance.

 

[karl dewey]

You can have an unbound text box on the form.

Form event 'On Open' run 'Macro_Once_Today' that has condition to check the
text box < Date() to run your append queries. Next action to Set Value text
box to Date().

 

[karl dewey]

Should read --
Form event 'On Open' run 'Macro_Once_Today' that has condition to check the
text box < Date() to run your append queries. Next action to Set Value text
box DEFAULT to Date().