Trigger click event on a different form

G

Guest

Hi,

I have 2 forms - for creativity let's call them A & B. "A" is the form that
gathers a lot of data from the user and saves this new adjustment to a table.
"B" is a form that gives you a preview of the effects of the adjustment
before it has been saved. Note that "B" is NOT a subform (I tried it that
way and just couldn't get it to work exactly as I wanted). There is a button
on "A" to save the adjustment. I want a button on "B" that will save not
only the adjustment - but also its subsequent effects. I would like to be
able to fire the save event on "A" from form "B" (in addition to some other
code on "B"). So it boils down to:

Does anyone know how to trigger the click event of a button on form B from
the click event on Form A?

Thanks!
 
G

Guest

Apparently I hadn't played with the syntax enough. Here's what worked in the
click event on form B:

Forms![A].Save_Click

I think a fundamental axiom of the newsgroup universe is that posting a
question to a problem invariably causes one to determine his/her own solution
upon hitting "Post".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top