VBA Error - invalid reference to the property

[BBBryan]

Hi,
Can someone help me.
I have a form with 3 levels.
main - [Welders fm],
2nd level - [PipingQualificationTickets tbl Subform]
3rd level - [WelderWps fm] This is a pop up form but is related to the 2nd level formVBA Error

I have a dropdown box [Wps] (3rd Level PopUp) with an after update function to lookup a query [DLookUpWeldWPS Qy] and insert the text into [Wps(s)QualifiedFor] on the 2 level [PipingQualificationTickets tbl Subform]

Here is the code,
Forms![Welders fm]![PipingQualificationTickets tbl Subform].Form![Wps(s)] = DLookup("[Wps(s)QualifiedFor]", "[DLookUpWeldWPS Qy]", "[WelderWps tbl]![QualificationID] = " & Nz(Forms![Welders fm]![PipingQualificationTickets tbl Subform].Form![WelderWps fm]![QualificationID], 0))

I am getting an error - You entered an expression that has an invalid reference to the property form/report

The names are all correct to the forms.

An ideas what I can do to fix this.

Thanks BBryan

 

[Mihail]

Hi. I can't debug your code but, maybe, this will help you:
Forms: Refer to Form and Subform properties and controls

 

[BBBryan]

Hi Mihail,
Thanks for that is helped me out.It is a very good reference sheet.

Thanks BBryan