L
LT
I am running a submission database that has a main form and three subforms.
The subforms all refer to lookup tables while the main form contains the
contact details and those questions that don't have lookups. The submission
ID number is the main form's primary key, which links into the subforms (but
is not the primary key in the subforms as each submission can have multiple
answers in the subform).
Two problems have arisen. The first is that after entering the primary key
in the main form and begining to enter text into the subforms, the primary
key 'disppears' and defaults back to 0. The first time it happened only the
subform entries changed to 0, but the second instance it happned both the
main form and subform changed to 0. It is happening when I am tabing between
fields on the main form.
The second problem, which happened at the same time as the first problem, is
that the entries in the form are being reordered ie. the entries where
entered 1-6 and now they are ordered 5, 6, 3, 4, 1, 2. However they are in
the right order in the tables.
The subforms all refer to lookup tables while the main form contains the
contact details and those questions that don't have lookups. The submission
ID number is the main form's primary key, which links into the subforms (but
is not the primary key in the subforms as each submission can have multiple
answers in the subform).
Two problems have arisen. The first is that after entering the primary key
in the main form and begining to enter text into the subforms, the primary
key 'disppears' and defaults back to 0. The first time it happened only the
subform entries changed to 0, but the second instance it happned both the
main form and subform changed to 0. It is happening when I am tabing between
fields on the main form.
The second problem, which happened at the same time as the first problem, is
that the entries in the form are being reordered ie. the entries where
entered 1-6 and now they are ordered 5, 6, 3, 4, 1, 2. However they are in
the right order in the tables.