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

[Ruegen]

I have a button on a pop up form that when it closes refreshes the subform on the next form that it opens.



I need to refresh the form. I tried on load with no success.

Private Sub Form_Load()
Me.frmBookingsSubJoin1.Requery
Me.frmBookingsSubJoin2.Requery
Me.Refresh
End Sub

And

Private Sub Form_Load()
Me.frmBookingsSubJoin1.Form.Requery
Me.frmBookingsSubJoin2.Form.Requery
Me.Refresh
End Sub

[June7]

Don't understand, if form is just being opened, why do you need to run requery or refresh on it?

[Ruegen]

Don't understand, if form is just being opened, why do you need to run requery or refresh on it?

The first form is for viewing the records in the subform where as the second main form allows you to add those records (the subforms are locked and are for viewing and editing purposes but not adding purposes).

So you are on the first form, you see a list of schools with some editable details like a contact (it's a continuous form) then you press a button on the main and it opens up a form for searching for the schools. When you click the school it ads the id to the table/subform and you then add that school into the records.



It's a work in progress. Basically when done adding the school on the other form, after closing I need it to refresh the form shown above subform.



This is the form to add a school to the other form.

[June7]

Forcing a requery/refresh of a form from code in another form is easy, I do that. What I don't understand is putting that code in Load event of any form.

[Ruegen]

Forcing a requery/refresh of a form from code in another form is easy, I do that. What I don't understand is putting that code in Load event of any form.

It didn't work on the open form - I'm willing to try anything to get it to work.

[June7]

I seem to have a similar situation:

1. I have a form that is used to 'manage' records. Has tools to search and filter records and initiate tasks, such as create a new record or edit record or print report of record. Controls in unbound main form header for those operations and a subform displays existing records for quick review of data and as one option to select a record (locked against editing).

2. Buttons initiate tasks to create new record or edit existing by opening a data edit form, user completes edits and closes form

3. code in item 2 form custom 'close' button refreshes form/subform in item 1

[Ruegen]

I seem to have a similar situation:

1. I have a form that is used to 'manage' records. Has tools to search and filter records and initiate tasks, such as create a new record or edit record or print report of record. Controls in unbound main form header for those operations and a subform displays existing records for quick review of data and as one option to select a record (locked against editing).

2. Buttons initiate tasks to create new record or edit existing by opening a data edit form, user completes edits and closes form

3. code in item 2 form custom 'close' button refreshes form/subform in item 1

So how do I ask that close button to refresh the other form?

[June7]

The syntax I use is:

Form_mainformname.Refresh

In another form I use:

Form_mainformname.subformcontainername.Requery

[Ruegen]

The syntax I use is:

Form_mainformname.Refresh

Form_mainformname.subformcontainername.Requery

Mainform refreshes however, sub1 is supposed to requery showing only the schools with hosting unchecked. sub2 should be schools checked. Sub1 is showing results for those checked and unchecked and should be just unchecked (the refresh list button that refreshes the main form fixes that but I was hoping the syntax you provided would do that). Sub2 does nothing (it should see the new school added with checkbox true)

[Ruegen]

DoCmd.SaveMe.JoiningSchool = True
Form_frmBookingJoining.frmBookingsSubJoin2.Requery
Form_frmBookingJoining.Refresh
DoCmd.OpenForm "frmBookingJoining"
DoCmd.Close acForm, "frmBookingJoiningSearch", acSaveYes

This is what I have on the close button.

[June7]

Apparently I don't understand your data relationships and form designs enough to respond intelligently. If you want to provide db for analysis, follow instructions at bottom of my post.

[Ruegen]

I think I'm partway there - it's refreshing the form just not refreshing the subforms..

[June7]

I am really confused. If frmBookingJoining is not open then there is nothing to refresh.

[Ruegen]

I am really confused. If frmBookingJoining is not open then there is nothing to refresh.

You are using frmBookingJoining. It stays open. There is a button that you click it opens frmBookingJoiningSearch as a popup which allows you to search for schools and put in a name for the teacher who is joining in that form. When you close frmBookingJoiningSearch you go back to using frmBookingJoining (because it is already open) and when that happens I am hoping the subforms refresh with the newly added school.

[June7]

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

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.