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!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dlookup type mismatch 1

Status
Not open for further replies.
din2005

din2005

Programmer
Mar 22, 2005
162
GB
Hi i have a type mismatch on this piece of code

strDate = Nz(DMax("Date", "patientevent", "Hospital= '" & Me!Text820 & "'" And EventType = "Entered Waiting List"))

can't seem to know whats wrong with it???
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

JaineyBlue
  • Locked
  • Question
DLookup with criteria 1
Replies
2
Views
350
JaineyBlue
JaineyBlue
VicM
  • Locked
  • Question
DLookup throws TypeMismatch after setting Option Explicit in module
Replies
4
Views
156
MajP
MajP
sparkbyte
  • Locked
  • Question
Looking up a GUID with DLOOKUP returns ?????????
Replies
2
Views
161
sparkbyte
sparkbyte
kopy
  • Locked
  • Question
Error 13: Type MisMatch 1
Replies
6
Views
156
strongm
strongm
Tomadams
  • Locked
  • Question
Error 3251 Operation not supported by this type of object.
Replies
5
Views
208
Tomadams
Tomadams

Part and Inventory Search

Sponsor

Back
Top