Syntax for field name in recordset

[Budatlitho]

Hello!

I have a table field named "Participant Member Number (7-digits)"

I want to refer to it in an open recordset like this:

 amountdue = DSum("[Order amount]", "Jumbula", _
            "[Participant Member Number (7-digits)] =""" & eid & """")

What is the proper syntax for this field name?
Debug gives "Run-time error "3265':


Item not found in this collection"


Thanks in advance.

[Micron]

How do you know which is not found, Participant or eid? If eid is a number try
DSum("[Order amount]", "Jumbula", "[Participant Member Number (7-digits)] = " & eid)

That field name is awful. You should avoid any special characters (except possibly underscore) in object names.

[orange]

Further to Micron's suggestion, I would add -- no spaces in field names.

You should post the complete code involved and also where exactly the error occurs.
You could also show us the design of table Jumbula

Use Debug.print "amount Due " & amountdue to show the value.

[Welshgasman]

Hello!

I have a table field named "Participant Member Number (7-digits)"

I want to refer to it in an open recordset like this:

 amountdue = DSum("[Order amount]", "Jumbula", _
            "[Participant Member Number (7-digits)] =""" & eid & """")

What is the proper syntax for this field name?
Debug gives "Run-time error "3265':
Item not found in this collection"


Thanks in advance.

You don't have to have a field name like that. You can have a caption for the field that is like that if you have to have such a long name
I never had any spaces in any field names. I used captions a fair bit.

[Budatlitho]

Thanks for the suggestion.

How do I implement captions?

[Welshgasman]

In the table to have them everywhere.
Or in the label of the control.