Link Criteria Problem

  • Thread starter Thread starter Merwin12
  • Start date Start date
M

Merwin12

Having a type mismatch on this one:
Date_returned is datetime while Client_id is integer

stLinkCriteria = "[Date_Returned]=" & "#" & Me!
[txtDateReturnedNow] & "#" And "[CLIENT_ID]=" & Me!
txtClient_id

Please help. thanks.
 
stLinkCriteria = "[Date_Returned]= #" & Format$(Me![txtDateReturnedNow],
"mm/dd/yyyy") & "# And [CLIENT_ID] = " & Me!txtClient_id
 
Thanks a mil!
-----Original Message-----
stLinkCriteria = "[Date_Returned]= #" & Format$(Me! [txtDateReturnedNow],
"mm/dd/yyyy") & "# And [CLIENT_ID] = " & Me!txtClient_id

Having a type mismatch on this one:
Date_returned is datetime while Client_id is integer

stLinkCriteria = "[Date_Returned]=" & "#" & Me!
[txtDateReturnedNow] & "#" And "[CLIENT_ID]=" & Me!
txtClient_id

Please help. thanks.
Click to expand...


.
Click to expand...
 
Back
Top