New to VBA/Modules: Enter value to produce related reports

[kvt]

Hi, I posted on here earlier about help for creating an application. I am fairly new to Access and very unfamiliar with modules and VBA so my question may be either impossible or simple to answer - I appreciate any guidance that can be offered.

I have a table (blue circle in picture attached) with identification # in one field (SOC ID # is the field label) and SKU #s in the other. There is only one SKU per record. However some SKUs have the same SOC ID # as other records so it is not a primary key. There is a relationship between the SOC ID # on the blue circle table and the SOC ID # of three tables (seen marked with red star attached). There are three reports created from three queries between each red star table and the green heart table.

I want to be able to type in the SKU from blue circle table and pull up all three of the corresponding reports with the same SOC ID # in print preveiw mode.

I understand that this can be done through a filter, but I would like to make this accessible to many people in the company who don't have Access experience at all. Any help would be appreciated, thank you!!

 

[pbaldy]

Given "some SKUs have the same SOC ID # as other records", if you enter an SKU, which SOC ID should the reports be based on? This is one option, but would require a combo to have access to the SOC ID:

http://www.baldyweb.com/wherecondition.htm

At some point you'll regret the use of spaces and symbols in your object names.

 

[Ranman256]

For users who don't know Access,you use forms.
Create a main menu form,users can click a button to get what they want.
Either other forms,or reports.
To open a report ,filtered, the user can pick a SKU from a drop box on a form ,the the query will read this.
The report can open using this query.

Docmd.openreport "rMyRpt"

The qry: select * from table where [sku]=forms!frmMain!cboSku