Thanks for settting me straight on "multi-table query" issue! I expected
that my inability to "relate" to the multi-table part of your original answer
was probably due to my novice background. With your current explanation,
I've learned another piece of the Access puzzle (in addition to the piece
about creating a Form with sub-forms, with each sub-form bound to a single
table). Your help has "unstuck"me, on my current project. Now, I can move
forward. Yea! Thanks! Very appreciated. (Learning about the RecordSource
property of a Form was cool, too!)
--
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