Cascading Combo Box and Subform

[Guest]

I know that this question has been asked many times but for some reason i
caanot seem to apply the answers to my problem.

I have Three Cascading Combo Boxes that work great in there own form, once
it is used as a subform i get a prompt to enter a value


I have this for the after update on the first combo box

Private Sub cbovendor_AfterUpdate()
Me.cbopartnumber.Requery
End Sub

this is what i have on the second combo box as row source

SELECT DISTINCTROW tbl_Parts_Cost.Part_Number, tbl_Parts_Cost.Parts_ID FROM
tbl_Parts_Cost, tbl_Vendors WHERE
(((tbl_Parts_Cost.Vendor_ID)=Forms!frm_Projects_Parts_List_Subform.Form!cbovendor)) ORDER BY tbl_Parts_Cost.Part_Number;

I'm hoping for a solution that i can understand.

I get the problem only only when using this as a subform

 

[Michel Walsh]

Hi,



Your problem comes for "reaching" the control. Since your code is probably
in the SUBFORM, and you wish to reach a FORM control, you have to change the
syntax. Take a look at http://www.mvps.org/access/forms/frm0031.htm


Hoping it may help,
Vanderghast, Access MVP