save current form and open another form using a single command button?

  • Thread starter Thread starter moe leaer via AccessMonster.com
  • Start date Start date
M

moe leaer via AccessMonster.com

I am looking for a way to use a single command button to first save data in
my form, then open another form that writes information to the same line as
the first form.

The reason for this is that I have been getting errors when users open the
second form without saving. Access feels that two forms are writing to the
same line and it is not happy.

Does anyone have a solution to this problem of mine?

Thanks again guys,

Moe
 
I'd run the button wizard and select "record operations" and Save to get the
button and first bit sorted. Then run the wizard again and choose "Form
operations" and Open Form. Then, merge the 2 together.
 
I have another save record command button made in order to merge it with my
action button, but I do not know how to perform a button merge, Any
thoughts?

Thanks sooooo much,

Moe
 
You can go:

me.Refresh
docmd.OpenForm "ther other form",,,"id = " & me!id

The above would save the current record, and then open the other form to the
same record...
 
Back
Top