Can Somebody Help me, What the syntax Error IS

[sadiqsabia]

I need Help please. I am trying to do a chooser form similiar to one user had posted.

PICOffen- Text
PICNos-Number
ChapOff-Text

I have input the following code in the queries but i get syntax error.

The Whole line is as below.

DCount("[PICOffen]","tblPICItems","[PICNos]
= " & [[Forms]![frmRecords]![tblPIC subform].[Form].[PICNO]] & " And [PICOffen] ='" & [ChapOff] & "'")

 

[stopher]

You seem to have extra brackets (shown in red). Try removing them.

DCount("[PICOffen]","tblPICItems","[PICNos]= " & [COLOR="Red"][[/COLOR][Forms]![frmRecords]![tblPIC subform].[Form].[PICNO][COLOR="Red"]][/COLOR] & " And [PICOffen] ='" & [ChapOff] & "'")

If that doesn't work, try writing the expression with real valid values

DCount("[PICOffen]","tblPICItems","[PICNos]= 23 And [PICOffen] ='aChapOffvalue'")

hth
Chris

 

[sadiqsabia]

You seem to have extra brackets (shown in red). Try removing them.

DCount("[PICOffen]","tblPICItems","[PICNos]= " & [COLOR="Red"][[/COLOR][Forms]![frmRecords]![tblPIC subform].[Form].[PICNO][COLOR="Red"]][/COLOR] & " And [PICOffen] ='" & [ChapOff] & "'")

If that doesn't work, try writing the expression with real valid values

DCount("[PICOffen]","tblPICItems","[PICNos]= 23 And [PICOffen] ='aChapOffvalue'")

hth
Chris

Removing the brackets helped. I thought i was just grouping them by putting the brackets