subform requery (beginners level)

[chancer1967]

Apologies in advance for the basic nature of this, but in the past two years I have forgotten everything i ever knew!


I have two tables - Holders (holderID, name, current address) and Addresses (addressID, address1, city, etc)

current address is linked to addressID


I am trying to create a form (frmHolders) that shows the details from holders and pulls in the address using a subform (sfrmHolders)

On the main form I have used a combo box for current address so that it can be changed. What I want is for the address on the subform to refresh when the current address is changed in the combo.

I am using this:

Private Sub cboAddress_Change()
Me!sfrmHolders.Requery
End Sub

and it doesnt work


where did i go wrong?



thanks
chancer

 

[llkhoutx]

Check your subform Master/Child links. They may not be set.

I use a lot of subform switching. It's easier for me to use the

forms!MainFormName!SubFormName.form.requery

Maybe you should also try me!SubFormName.form.requery.

I'm not big on Me! Me., but that's me.