I have a data entry form based on a query.
As a user enters data in the fields, I want to check if that data exists in
the underlying table.
I have tried Dlookup on the table and also a recordset.open with a select
query
the error message I get trying to open the recordset is along the lines of
:
"The connection cannot be used to perform this operation.
It is either closed or invalid in this context"
I am sure this must be a common operation and I am probably making some
basic errors and omissions.
Any pointers on how I can resolve this would be very much appreciated
Regards
PeterW