Problem with ECount function

[arunakumari02]

I have a problem with ECount.

The statement generates an error:

int X = ECount("[ID]", "tblResource", "[ProjectID] =" [B]& labID[/B], True)

The Ecount should generate unique values of ID from the tblResource where projectId = labID

Error says & labID sub or function not defined. (labID is in the form with a number)

Any help

 

[arunakumari02]

Any help on ECount function.

 

[stopher]

Ecount is not a standard Access function. I'm guessing you may be using Allen Browne's code here?

Perhaps you could post the code for Ecount. Also post the rest of your code before and after the statement.

My guess is you haven't defined what labID is.

Chris

 

[CyberLynx]

X = ECount("[ID]", "tblResource", "[ProjectID] =" & Me.labID, True)

.

 

[arunakumari02]

X = ECount("[ID]", "tblResource", "[ProjectID] =" & Me.labID, True)

I still get error says that &Me.labID function or sub not defined.

Any help

 

[dkinley]

a) Is labID the name of the control on the form, or, the data that is in a control?

b) Is this x = .... in a form event or is it in a module?

-dK

 

[arunakumari02]

labID is a label in the form which has a value.

 

[dkinley]

Me.LabelName.Caption

-dK

 

[arunakumari02]

Hey the label gets value from different form.

Any Help

 

[dkinley]

It shouldn't matter because you are pointing to the label as long as the label has its information prior to you executing the EFunc.

Why not point the EFunc you have to the same form and control that the label gets its value from?

-dK