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

form/subform problem 1
Scanning records of form+subform 1
Requery List Box from another Form 2
Sending value and {Enter} to control on second form 1
Open form relative to another form 1
Looping through subforms ? 4
Open a form using Openargs 3
Can't figure out nested subform and requery syntax 1

Top