Run time error 3075

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

i am getting a run time error 3075

varX = DLookup("[Ticket #]", "Remedy Tickets", "[Ticket #] =" _
& Forms![Remedy Tickets]![Remedy Tickets Table subform]![Ticket #])


varX defined as variant, ]Ticket #] is a primary key (Number Data Type)

Thanks
 
The correct syntax for referring to a control on a subform is

Forms![NameOfParentForm]![NameOfSubformControlOnParentForm].Form![NameOfControlOnSubform]

Depending on how you added the form as a subform, the name of the subform
control on the parent form may be different than the name of the form used
as a subform.
 
Back
Top