Run time error 3075

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using an ActiveX control instead of multiple Access controls 0
Using a subform to show newrecord on the main form 1
Populating main form after changing selection 0
Refreshing main form from the subform 1
Access mdb or SQL Server Back End? 4
Problems with code 11
DLookup error 1
Foreign Key 1

Top