L
lizo.consulting
I am working on a database to tracks students in a school. I've built
my table structure and set up my relationships, but am having trouble
with an error on a subform: expected: list separator or ). I am pretty
experienced with access and have never never encountered this problem
before.
The error is occuring on a subform to Track Parents (data source is
"Tbl Relationships") on the master "StudentForm" (data source is "tbl
Students"). Subform is linked to master via a shared field --
studentid.
The purpose of the subform is to allow grownups (e.g.
parents/guardieans, emergency contacts, etc) to be assigned to a child.
On the subform, the user picks a grownup from from a Combo Box (list
stored in the "tbl grownups") and then picks a "relationship" from a
Combo Box (relationship list is stored in the "lst Relationships"). The
studentid is automatically entered, as is the relationshipid autonumber
field.
When I try to create a new record either by picking from the parent or
relationship combo, database returns "expected: list separator or )".
The error occurs ONLY when I am adding a new record. Once the error
occurs, i am able to change the entries.
Also, the error does not occur when I work with the subform separate
from the parent form, only when it is displayed on the master form,
linked by student id.
Any hints for me what might be happening?
Liz O'Donoghue
(e-mail address removed)
my table structure and set up my relationships, but am having trouble
with an error on a subform: expected: list separator or ). I am pretty
experienced with access and have never never encountered this problem
before.
The error is occuring on a subform to Track Parents (data source is
"Tbl Relationships") on the master "StudentForm" (data source is "tbl
Students"). Subform is linked to master via a shared field --
studentid.
The purpose of the subform is to allow grownups (e.g.
parents/guardieans, emergency contacts, etc) to be assigned to a child.
On the subform, the user picks a grownup from from a Combo Box (list
stored in the "tbl grownups") and then picks a "relationship" from a
Combo Box (relationship list is stored in the "lst Relationships"). The
studentid is automatically entered, as is the relationshipid autonumber
field.
When I try to create a new record either by picking from the parent or
relationship combo, database returns "expected: list separator or )".
The error occurs ONLY when I am adding a new record. Once the error
occurs, i am able to change the entries.
Also, the error does not occur when I work with the subform separate
from the parent form, only when it is displayed on the master form,
linked by student id.
Any hints for me what might be happening?
Liz O'Donoghue
(e-mail address removed)