Creating a form that uses many queries from many tables

[surfside1]

I inherited an Excel file that is very cumbersome for the folks using it and they also use Access prior to creating an Excel report. What they do is run queries using ODBC to go to Oracle using Make Table queries. Then they have other queries (20+) that they do alot of various criteria to get the results they need for the Excel report. Get this - they cut and paste the results of the queries in other worksheets. Then the final report does alot of lookups and calculations to get the end result.

I'm trying to mimic their process in Access and elimate the Excel report and instead create a form in Access (because they also update some fields). When the form opens it runs the macros that run all the queries and return the results to the form. Then they can update the fields they need to. Then I will give them the capability to output the form to Word.

Now, my problem is figuring how to point to all the various recordsources (which are query results and tables) when building the form using the form wizard. How does someone accomplish this? It tells me to either use the queries or the tables, not both.

I appreciate anyone taking the time to read all this - thanks! Surfside1

I know this was long winded, but I wanted to make clear

 

[ChanceD2]

Surfside,

That is not long-winded at all. Actually there is more detail needed. Anyhow, first and foremost you need to write down EVERYTHING that you need this form to do. Then take it one step at a time. Get each step working. Make them independent of each other that way if you screw one up you are not affecting the others. Your question is pretty general, so I am not sure what you are looking to have answered.

C-D2