Many thanks Steve ... yes you are right, I should have given an example,
will do next time.

ebay

"Steve Schapel" wrote in message
...
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"

--
Steve Schapel, Microsoft Access MVP


Abay wrote:
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