Hello!
I have a table field named "Participant Member Number (7-digits)"
I want to refer to it in an open recordset like this:
What is the proper syntax for this field name?Code:amountdue = DSum("[Order amount]", "Jumbula", _ "[Participant Member Number (7-digits)] =""" & eid & """")
Debug gives "Run-time error "3265':
Item not found in this collection"
Thanks in advance.