Best method of combing multiple Tables to an access form/populating data based on criteria

[Jeff123!!]

I'm trying to create a form that's to be used as a sort of ROI calculator. The way it works the costs need to be based off several factors that, when certain criteria is selected, fields will populate data based on those selections. It's a bit involved and I'm not able to add all the data into a single query, it need's to pull from multiple tables.

It's a bit difficult to explain but here is the general gist of what I'm attempting:



In my main form there are fields based off the query it was created with, and other fields I added myself.

Model: Field from Query Report it's based on
Sides?: Combo box I added, records typed in manually
Paper Weight: Combo box populating records from a table

My goal is to add data from another table that will be based on these 3 criteria. The table itself has matching data from the above three fields that can be used to filter the specific data I need to show. I know little to no VBA but I'm usually able to manipulate it if I find code online. My first attempt was to embed macros in the field that will apply filters but I'm really not sure how to do that either. I've used Dlookup for a few fields but I don't believe that can be combined with multiple criteria.

Any help will be greatly appreciated. Please feel free to ask for more information more than happy to provide.

Thank you.

Here is a screen shot to get a better idea of what I'm attempting. The BW IPM and CLR IPM are the fields that need to be filtered further. Right now I have it linked to the model name, but it also needs to take into account the sides? field and paper weight field, which all have matching records in the table BW IPM is from.

EDIT: I've attached a clean version of the db if you would like to look. Hopefully this gives a better idea of what I'm trying to accomplish. The "Print Speeds v3" Table is what i'm trying to add in that will filter based of the 3 mentioned criteria.

[orange]

I suggest you do not get too focused on vba or macros. Probably better for you and communications if you describe in plain English what you are trying to achieve. Describe the input factors and the calculation(s) involved so you and readers understand the issue.
Once readers know what is involved (data and calculation(s)) they may offer some focused ideas on structures and processing.
Good luck with your project and welcome to the forum.

[Micron]

Agree with Orange, but can add a point or two. If you have a query that involves multiple tables and you must build a single form based on this, then design the query first. If you can't edit it, then forget the form. That is one of my Access Commandments. The typical approach is a main form/subform relationship but it's impossible to say if what you've got will support that.

[June7]

Domain aggregate functions certainly can utilize multiple criteria.

Essentially, it appears the IPM table has a 3-field compound key relationship with primary data table.

If you want to provide db for analysis, follow instructions at bottom of my post.