How to update records in Form based on query

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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
 
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.
Click to expand...

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.
 
Back
Top