Dlookup (1 Viewer)

[Len Boorman]

Have an opening form prompting for user ID and password

Have a query qry_Password uses then inputs as parameters

Trying to use DLOOKUP to determine if credentials supplied match query results. i.e. Does query return a record

Basic first part of Event procedure as below

If Not IsNull(DLookup("[Queries]![qry_Password]![Logon]", "[Queries]![qry_Password]![Logon]")) Then

Do other things

End If

Getting run time error 64231

Cannot find input table or query Queries]![qry_Password]![Logon

Tried several things but no joy so far, Have checked spelling and all appears okay

Advice appreciated

Len

 

[Len Boorman]

Just when you think you have tried everything and post on the forum you see the error of your ways

This Forum helps in many different ways

Len