Len Boorman
Back in gainfull employme
- Local time
- Today, 11:08
- Joined
- Mar 23, 2000
- Messages
- 1,930
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
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