Full Version: Run a Macro when a form is run
UtterAccess Forums > MicrosoftŪ Access > Access Forms
Hey I had a question about what event field for my form would be right for wanting to run a macro whenever I started the form. Also, I know this part should go into the macros/tables forum but its related so what the heck. The macro that I want to run when the form starts up is to delete the contents of a table (NOT THE TABLE) and I was wondering about how to do that.

Edited by: OfflinePK on Mon Jun 11 14:29:38 EDT 2007.
Doug Steele
The form's Open event would likely be the best place to delete the data that's going to be bound to the form. You could also do it in the form's Load event, but you'd likely need to do a Requery on the form then.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.