Requery 2nd subform

[chopper57 via AccessMonster.com]

Need help to requery subform from a popup. This is what I have:

frmMainForm
sfrmDailyReports (on frmMainForm)
sfrmEmployeeHours (on sfrmDailyReports) datasheet type

pfrmEmployees (popup to update Employee info)

I'm trying to get the popup to requery the sfrmEmployeeHours after add new
record.
I see a lot of references to requery a first subfrom but couldn' t fine any
on a secound .

To get to the popup I first open a popup (located on sfrmDailyReports) which
lists five buttons for updating other data, this is how I open the popup for
updating Employee info.

Been trying a lot of things that I see on the site but with no luck so far.
Right now I just close and reopen the database to update.

 

[RuralGuy]

Need help to requery subform from a popup. This is what I have:

frmMainForm
sfrmDailyReports (on frmMainForm)
sfrmEmployeeHours (on sfrmDailyReports) datasheet type

pfrmEmployees (popup to update Employee info)

I'm trying to get the popup to requery the sfrmEmployeeHours after add new
record.
I see a lot of references to requery a first subfrom but couldn' t fine any
on a secound .

To get to the popup I first open a popup (located on sfrmDailyReports) which
lists five buttons for updating other data, this is how I open the popup for
updating Employee info.

Been trying a lot of things that I see on the site but with no luck so far.
Right now I just close and reopen the database to update.

Let's try

Forms!frmMainForm!sfrmDailyReports.Form!sfrmEmployeeHours.Form.Requery

This assumes that the SubFormControls are named the same as the SubForm they
display.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[chopper57 via AccessMonster.com]

That works, thanks a lot!!

Need help to requery subform from a popup. This is what I have:

[quoted text clipped - 15 lines]

Been trying a lot of things that I see on the site but with no luck so far.
Right now I just close and reopen the database to update.

Let's try

Forms!frmMainForm!sfrmDailyReports.Form!sfrmEmployeeHours.Form.Requery

This assumes that the SubFormControls are named the same as the SubForm they
display.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[RuralGuy]

That works, thanks a lot!!

Glad I could help.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.