How to update records in Form based on query

[Jennifer]

I have a form based on a query with multiple sources (tables). I need to be
able to add new records in the form that will ultimately update a new table
and/or query.

What is the best way to do this? I tried to set a command button to add a
new record but that doesn't work. I could possibly do a sub-form but don't
know what source to use.

Thanks

 

[John W. Vinson]

I have a form based on a query with multiple sources (tables). I need to be
able to add new records in the form that will ultimately update a new table
and/or query.

What is the best way to do this? I tried to set a command button to add a
new record but that doesn't work. I could possibly do a sub-form but don't
know what source to use.

Typically a Form based on the "One" side table (or the "One-est") with
Subforms for the many is the best bet. Using "One Great Master Query" tying
all your tables together is generally a bad idea, for exactly the reason
you're seeing.

We have no way to know what source to use either, since you chose not to post
any information about your tables.