One form to multiple tables?

[GD]

Is it possible to link data entered into one form back to multiple tables
without using subforms? Or are subforms required to do this?

I have a form that contains quite a bit of information. Specifically,
though, each record has the potential of having multiple comments from users
at any given time. I'd like to bind the comments (+date, +user) back to a
different table than the rest of the form. Can this be done?

 

[Jeff Boyce]

It sounds like you might be trying to work from a form to the tables.

In MS Access, you start with the tables, then build forms to display the
data.

One reason for using a main form/subform construction is to display
(add/edit/...) data that is related as "parent to children".

Describe how your data is related to get more suggestions on how to design
forms to support it...

Regards

Jeff Boyce
Microsoft Office/Access MVP