Help with dCount - “Data Type mismatch in criteria expressionâ€

[FatMan]

Hi all:
The code listed below is giving me a “Data Type mismatch in criteria
expression†error.

Code:
Me.txtBinsScanned = DCount("[BatchNum]", "[tblPreSortBatchBackup]",
"[BatchNum]=" & [Forms]![frmTraceBox]![txtBatch])


Where:
BatchNum data type is text

TxtBatch is a text box on my form that is getting its value through a
dlookup function and the results being returned are from a text field from a
different table. It works and the code for it is:

Me.txtBatch = DLookup("[InFriutTransLog]", "[tblIntake]", "[IntakeID]=" &
[Forms]![frmTraceBox]![txtIntakeID])

All help is greatly appreciated.

Thanks,
FatMan

 

[Douglas J. Steele]

Since BatchNum is text, the value being passed must be in quotes:

Me.txtBinsScanned = DCount("[BatchNum]", "[tblPreSortBatchBackup]",
"[BatchNum]='" & [Forms]![frmTraceBox]![txtBatch] & "'")

Exagerated for clarity, that's

"[BatchNum]= ' " & [Forms]![frmTraceBox]![txtBatch] & " ' ")

 

[FatMan]

Doug:
You da man!

Thanks,
FatMan

Since BatchNum is text, the value being passed must be in quotes:

Me.txtBinsScanned = DCount("[BatchNum]", "[tblPreSortBatchBackup]",
"[BatchNum]='" & [Forms]![frmTraceBox]![txtBatch] & "'")

Exagerated for clarity, that's

"[BatchNum]= ' " & [Forms]![frmTraceBox]![txtBatch] & " ' ")

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Hi all:
The code listed below is giving me a "Data Type mismatch in criteria
expression" error.

Code:
Me.txtBinsScanned = DCount("[BatchNum]", "[tblPreSortBatchBackup]",
"[BatchNum]=" & [Forms]![frmTraceBox]![txtBatch])


Where:
BatchNum data type is text

TxtBatch is a text box on my form that is getting its value through a
dlookup function and the results being returned are from a text field from
a
different table. It works and the code for it is:

Me.txtBatch = DLookup("[InFriutTransLog]", "[tblIntake]", "[IntakeID]=" &
[Forms]![frmTraceBox]![txtIntakeID])

All help is greatly appreciated.

Thanks,
FatMan

.