Requery a list on form from a subform (2000)

[Leesha]

Hi All,

I have a form called frmAccountsReceivable. This form contains a subform call sfrmPayment. I would like to requery a list on frmAccountsReceivable after updating a textbox on sfrmPayment. I'm not sure how to code this.

Thanks,
Leesha

[HansV]

To refer to the main form from the subform, you can use Parent. So you'd get something like this:

Private Sub txtSomething_AfterUpdate()
Me.Parent.lstOther.Requery
End Sub

[Leesha]

Hi Hans,

Thanks for the quick response. Would I use the same code if the after update is in a subform that is in a subform on the parent form?

Parent form = frmAccountsReceivable
frmPayment is a subform frmAccountsReceivable
within frmPayment is sfrmPaymentAllocations which is where the actual requery of lstEdit (on frmAccountsReceivable) should be happening.

Not sure if that makes sense.

Leesha

[HansV]

Since you want to requery a list box from two levels down, you would need Parent twice to refer to something on the main form.

Me.Parent.Parent.lstOther.Requery

[Leesha]

Thanks Hans!!!

Leesha