Saving a Record

[daniel]

I want to click a button on an appointment form that opens
another form called confirmation. If it is a new
appointment I want the appt record to be saved to the
table when the confirmation form opens up. I do not want
to close the appt form and I want to be able to access it
still behind the conf form. When I do a requery it saves
the info but makes my form blank. Is there a solution?

Thanks

Daniel

 

[John Spencer (MVP)]

In the code that calls the Confirmation form, you can add the following line.

If Me.Dirty = True then Me.Dirty = False

That will cause the form from which the code is being executed to save any
record attached to the form.