I am writing a Dlookup in VBA Access based on a table called tblStudents, looking for the job in job column when lastname is aXEN:
but I am getting an error saying "Object Required".Code:dim x as variant x = Dlookup(Tables!tblStudents![Job], Tables!tblStudents!tblStudents, Tables!tblStudents![LastName] = "aXEN") End Sub
This code is written in a normal module in VBA access called Module1.
Please advise.
Thanks!