Link Criteria Problem

[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.

 

[Treebeard]

stLinkCriteria = "[Date_Returned]= #" & Format$(Me![txtDateReturnedNow],
"mm/dd/yyyy") & "# And [CLIENT_ID] = " & Me!txtClient_id

 

[Merwin12]

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.

.