Search results

I'm using Access 2007, and trying to create a form that accesses data from multiple tables. I've created a query that pulls the data from those tables, and the form I'm using has that query set as a data source. When I go into Design View to put in the data entry fields, everything goes fine...

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

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

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?