Re: How to Remove Filter and Stay on Same Record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "doyle60@xxxxxxx" <doyle60@xxxxxxx>
Date: 1 Jun 2005 13:03:54 -0700

Thanks. I got it to work.

I needed to change a line in my code from

stLink Criteria = "[CBID]=" & "'" & Me![CBID] & "'"

to

stLink Criteria = "[CBID]=" & Me!CBID]

This solved a "Data type mismatch in criteria Expression" error.

Thanks,

Matt

.

References:
- How to Remove Filter and Stay on Same Record
  - From: doyle60@xxxxxxx
- Re: How to Remove Filter and Stay on Same Record
  - From: Tim Ferguson

Prev by Date: SQL INSERT INTO - Commas Problem
Next by Date: RE: SQL INSERT INTO - Commas Problem
Previous by thread: Re: How to Remove Filter and Stay on Same Record
Next by thread: Problems with programatically creating queries
Index(es):
- Date
- Thread

Relevant Pages

why this wont work!!??
... But this wont work!!! ... and always I receive the message: 'data type mismatch in criteria expression'. ... Prev by Date: ...
(microsoft.public.access.queries)
Re: How to combine values from 2 fields for a report
... >> I get an error that says Data type mismatch in criteria expression when I try ... >>> In SQL ... Prev by Date: ...
(microsoft.public.access.queries)
get the sql statement
... Data type mismatch in criteria expression. ... Protected Sub btnSave_Click(ByVal sender As Object, ...
(microsoft.public.dotnet.framework.aspnet)
Error 3464 with dCount - some computers only
... Error 3464 - Data type mismatch in criteria expression" from this line ... and produces a recordset with 36 records ... this code (and the print in the immediate window) ...
(microsoft.public.access.formscoding)
Re: Update query
... > It *should* set the value to NULL if the Allow Zero Length is false. ... Data type mismatch in criteria expression. ... Those are 2 single quotes... ...
(microsoft.public.access.queries)