Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't requery an object inside a subform 1

Status
Not open for further replies.

vanleurth

Programmer
Sep 1, 2001
156
US
Hi happy programmers !!

I have a very intriguing problem with access. I think I have tried any possible variation but perhaps you might have an additional one.
Here is the problem. I have a subform inside a parent form. On the parent form I have a button that opens a form in which you can add new records. Once the form is updated then a few combo boxes are supposed to perform a requery to there recordset so the new record's modification will show. Now, there is a comcobox inside the child (sub form) form that it is not recognized as an object of the form. Here is the code.


Private Sub btn_phonegroup_Click()
DoCmd.OpenForm "frm phones groups", acNormal, , , , acDialog
cmb_phgroup.Requery
cmb_choice.Requery
' THIS IS THE OBJECT THAT IS NOT RECOGNIZED BY THE COMPILER ???
Me.frm_phones_list_sub.cmb_phgroup.Requery

End Sub

Thank you in advance,

V.
 
Try referencing the object like this

Me![Frm_Phones_List].Form![Cmb_phgroup].Requery

Hope that solves it.

ChaZ
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top