Unbound Form with 2 Bound Subforms - one not showing updates

[Sinfathisar]

Hi All,

I have an unbound form with a combo box, a command button that runs an update/insert sql, and two datasheet view subforms (each bound). No defined Master/Child links and both subforms dataentry=No.

The combo box value is used as criteria for the subforms and I have a requery both subforms afterUpdate of the combo box.

The first subform always has corresponding records when a value is selected in combo box, and the second subform sometimes has no corresponding record until after the command button is clicked and a record is inserted.

The issue is this: the first subform automatically shows updated values from the update function when I select the subform control, but the second subform will NOT show the inserted record until the afterUpdate event is fired again from the combo box (ie - toggle between values in the combo box). I've tried adding a requery of the subform after the sql inserts, and resetting the record source to no avail. Is there a workaround? I would like the user to see a record has been added in the subform window immediately after the record was added.

Thank you!

 

[Sinfathisar]

Well I just tried this and it works, though I'm not sure if requerying every time the subform Enter event fires is overkill.

 Private Sub subformName_Enter()
Me.subformName.Requery
End Sub

Note: my subform Name is the same as the subform control/container name.

 

[RuralGuy]

See if either of these two links shed some light on the issue:

http://access.mvps.org/access/forms/frm0025.htm

http://access.mvps.org/access/forms/frm0031.htm