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 Rhinorhino 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
Joined
Mar 22, 2005
Messages
162
Location
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 Question
DLookup with criteria
Replies
2
Views
664
JaineyBlue
JaineyBlue
VicM
  • Locked
  • Question Question
DLookup throws TypeMismatch after setting Option Explicit in module
Replies
4
Views
367
MajP
MajP
sparkbyte
  • Locked
  • Question Question
Looking up a GUID with DLOOKUP returns ?????????
Replies
2
Views
351
sparkbyte
sparkbyte
kopy
  • Locked
  • Question Question
Error 13: Type MisMatch
Replies
6
Views
354
strongm
strongm
Tomadams
  • Locked
  • Question Question
Error 3251 Operation not supported by this type of object.
Replies
5
Views
433
Tomadams
Tomadams

Part and Inventory Search

Sponsor

Back
Top