Hi,
I am noticing this error while attempting to search for an record from two tables. Initially it worked with one table alone which just returns no records, But now I am looking for 2 tables where the 2nd Table gets returned in a label value. When I debug the error, it stops at the below line. I have attached the code as well. pls assist.
varReturnValue = CurrentDb.OpenRecordset(Query)(0)