Hi,
I try to summarize the number of records with a specific field value.
I use the follwing vba code:
me.txtNumberOf=DCount("StatusID","tblOffer","StatusID=1")
I get error code 438; The object doesn't support the property or method.
The anoying thing is that I've other similar DCount expressions in the same module that works. The difference I see is that I don't set any criterie in these expressens that are the same as my expression above ("StatusID"). This might be the point? Is it possible to have 'expression' the same as 'Criteria'?
Grateful for some advice, thanks.
I try to summarize the number of records with a specific field value.
I use the follwing vba code:
me.txtNumberOf=DCount("StatusID","tblOffer","StatusID=1")
I get error code 438; The object doesn't support the property or method.
The anoying thing is that I've other similar DCount expressions in the same module that works. The difference I see is that I don't set any criterie in these expressens that are the same as my expression above ("StatusID"). This might be the point? Is it possible to have 'expression' the same as 'Criteria'?
Grateful for some advice, thanks.