Macro / functton question

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

I have a command button on a form that when pressed I want to run a function
to update a field and then execute a macro which runs queries etc. and
produces a report. Can I execute a macro from a function i.e. after I have
done my update. I want them both to execute when the button is clicked.

There is probably a better way to do this & apologies is this is too dumb
for words .. learning as I go along ..

Some help would be much appreciated.

abay
 
Abay,

No, this is not "too dumb for words". But you will find when asking for
help in newsgroups that the more specific you can be, the easier it is
for others to understand you. Especially if you can give examples.

You can run a macro from within a VBA procedure by using...
DoCmd.RunMacro "NameOfYourMacro"
 
Many thanks Steve ... yes you are right, I should have given an example,
will do next time.

ebay
 
Back
Top