Updating multiple tables from one form.

[WesternActor]

I have done a fair amount of research on the web, and simply cannot get a workable answer to this question. I want to create a database that will allow a user to update (and view) information on multiple tables from a single form. How do I do this?

 

[boblarson]

Probably the most efficient way is to create subforms for each table and put them on a tab control on the main form.

 

[pono1]

You do this by basing your form on a query that selects data from multiple tables...

1. Create the tables, making sure the tables are properly related.
2. Create and save a query that uses the tables.
3. When creating your form, use the query as the recordsource (you can do this when creating a form using a step-by-step wizard).

Regards,
Tim

 

[pono1]

Or you can do what Bob said...

 

[WesternActor]

Is that really efficient? Is there no better way? I really want to make it look like everything is all a part of one form and not two dozen smaller forms. If there is really no other way to do this, I wouldn't mind going to that route, but if there is any sort of a web resource that explains how to do this, I would be most grateful. I'm not a complete Access novice, but my skills are extremely rusty, and as this is the first database I've ever built in Access 2007 I'm having to put up with learning a new interface as well.

 

[WesternActor]

3. When creating your form, use the query as the recordsource (you can do this when creating a form using a step-by-step wizard).

Wow, for whatever insane reason I won't even begin to attempt to guess, setting the query as the record source was the major step I was missing. It looks like that accomplishes exactly what I'm looking for. (Then again, it's late, and whether or not it will still look like that when I wake up in the morning is a different question.) Thanks!

One more thing, though: I want the user to be able to enter multiple values in certain fields, and I'm pretty sure I have all my table relationships set up properly to make that a possibility. Does that affect any of the query-form design at all? Will the user need to submit one value in a field first and then type in the second and submit that, or is there a better way to accomplish that?

Thanks again!