Given that the specific cause for not being able to enter a new record into
the Form was the Foreign Key fields (from tables 2 and 3) switching from
correct value to "0" (zero) value, any ideas why the two Foreign Key values
switched ???

(The value of the Foreign Key field from 2nd table switched from correct
value to zero, when data entry moved out of fields from 2nd table, and into
fields from 3rd table. The value of the Foreign Key field from 3rd table
switched from correct value to zero, when data entry moved out of fields from
3rd table, and into fields from 4th table.)
--
2nd_Stage_User


"Rick Brandt" wrote:

2nd_Stage_User wrote:
Rick,

Thank you for your reply! My problem didn't involve "queries"
(multi-table, or otherwise), so I wasn't able to relate the
multi-table query info to my problem. [snip]

You said...

"The Form was created from the fields of 4 tables, using the Form Wizard."

If the form was created from the fields of 4 tables then it IS based on a
multi-table query. If you used the form wizard then it just created the query
for you. Look at the RecordSource of the form in design view an dyou will see
it.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com