Use Parameter to perform a double lookup in a table?

[jrabenhorst]

Hey everyone, so here is my latest Access question. I work with a database within an insurance company and am currently building some forms to manage our new applications. On our applications we look up the height and weight of our policyholders in a table and assign them a certain number of debits based on those figures. I was wondering how I can enter the height and weight into a parameter when I run the report, and then have Access look up the value for me in a table, and produce the correct number of debits? Can access perform this feature?

 

[PHV]

Have a look at the 4th argument of the DoCmd.OpenReport method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886