Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by tpowers2424
-
Dlook up or Join Table Help
ok i am new to this site but i am trying to do a dlookup and it looks like this varResdNameID = DLookup("[FNAME]", "tblUNITS&PEOPLE", "[ROOMNUMBER] = '" & txtRMNUMBER.Value & "'") but when i run the app it comes back with this error: data type mismatch in criteria expression and i dont know...- tpowers2424
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
