Parameter from a Form

[Parker]

Set paramiter from a displayed form

I am running a parameter query to calculate the total of some values displayed on a sub form.

The parameter used is the client ID for the main form in which the subform resides.

Is there a way I can get Access to set the parameter based on the record displayed instead of having to type it in each time and then display the resulting total on the form?

Thanks

 

[dcx693]

Have the query reference the form field holding the clientID, so you don't have to type it in. Here is an article detailing that technique (and some others). It shows you how to reference a combo box, but referencing a different control is identical: Customizing Access Parameter Queries

 

[Parker]

Thanks DCX

exactly what I need

Pete

 

[dcx693]

No problem Spidey.