Refresh/requery suform on main form from a different main form.

[Ruegen]

Still confused. If frmBookingJoining is open why do you show code to open it after code to refresh it?

I don't need that code, I just thought implementing it would help make it work...

Close the Search form so record is committed to table then Requery the other form.

DoCmd.Close
Form_frmBookingJoining.frmBookingsSubJoin2.Requery

If this doesn't work I won't be able to help further without reviewing the db.

That's where I probably went wrong - I had

DoCmd.Close acForm, "frmBookingJoiningSearch", acSaveYes



after instead of before...

Update: that is what it was..... I just needed to put it after acSaveYes... duh me.

Once again June 7 - big thankyou

[June7]

The acSaveYes has nothing to do with saving the record, it is to save design changes, such as property settings of form or controls changed by code. I usually make sure the acSaveNo parameter is in effect.

Record is committed to table when form closes (by any method), move to another record, or run code (DoCmd.RunCommand acCmdSaveRecord).

[Ruegen]

The acSaveYes has nothing to do with saving the record, it is to save design changes, such as property settings of form or controls changed by code. I usually make sure the acSaveNo parameter is in effect.

Record is committed to table when form closes (by any method), move to another record, or run code (DoCmd.RunCommand acCmdSaveRecord).

noted - I will change it to no.