using a form to open another form

  • Thread starter Thread starter stephanie
  • Start date Start date
S

stephanie

I am using one form to access another form. I want some
of the information from the first form to appear on the
next form. The only way I can do that is to move to the
previous record, then back to the desired record, then
click on the link to move to the next form. I know
there's a way to do this...I've done it before, but I
can't remember how I did it.

Steph
 
It's not working. I put it in the first form on close.
Didn't work. Then I put it in the form to be opened on
open. Didn't work.
 
I had assumed that you have a button that is pressed, and it opens the other
form.


So, the logic we have should be:

save current data
open new form

In code, you can simply use:

me.refresh
docmd.OpenForm "the form name",,,"id = " & me.id

I would suggest you try the above code behind the button, and dump the use
of macros. They are hard to work with anyway.
 
Back
Top