subform requery

S

skk

Hi!
I have frmA(main), fsubB(subform of frmA), fsubC(subform of frmB). I want
to requery fsubC, when fsubB.combobox value changes/after update event. I've
tried below code and many others with no success. Please help. Thanks.

Forms![frmA]![fsubB]![fsubC].Form.Requery
Me.fsubC.Form.Requery
 
E

Evi

The correct syntax is
Me.Parent.fsubC.Requery


If fsubB is a subform, rather than just a combo box, and you have linked the
2 subforms using the Link Master/Child Properties, then the requery will go
into the OnCurrent Event of fSubB.

Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set focus to control on subform 0
Scanning records of form+subform 1
form/subform problem 1
Form sync via custom events independent of order of form opening 1
Open form relative to another form 1
Define Listbox value via VBA instead of query or table 3
Requery List Box from another Form 2
REquery Subform 1

Top