Hi, I am getting really confused with how to use Dlookup with navigation forms, if its possible at all!
if I have a navigation form with Form1 and Form2 as tabs on the menu , so I want to find what the HospitalID value is based
on the fldPatientID (which is also in Form2)
Form1
fldPatientID,txtPatientID
fldHospitialID, txtHospitalID
in Table1
Form2
fldPatientID,txtPatientID
in Table2
So in Form2 I want to look up fldHospitalID from fldPatientID in Table1
Dlookup(Forms!Form1!txtHospitalID,[Table1],Forms![Form2]![fldPatientID])
so what I am doing wrong with this?
if I have a navigation form with Form1 and Form2 as tabs on the menu , so I want to find what the HospitalID value is based
on the fldPatientID (which is also in Form2)
Form1
fldPatientID,txtPatientID
fldHospitialID, txtHospitalID
in Table1
Form2
fldPatientID,txtPatientID
in Table2
So in Form2 I want to look up fldHospitalID from fldPatientID in Table1
Dlookup(Forms!Form1!txtHospitalID,[Table1],Forms![Form2]![fldPatientID])
so what I am doing wrong with this?