Using a subform to set the parameter value

C

clemenke

Is there a way to click on a value in a subform and open a form with a
parameter value without having to type that value.

I have a switchboard containing a bunch of accounts in a subform, I
would like the uses to be able to click on a certain account to open
another form. Right now when you open the form is asks for the
account to narrow the query, but I would like to remove that step.

Second part is that the form that is being opened also has multiple
subforms on it, each one requiring that parameter value question. I
would need to set them all to the name that is clicked on.

Any help???
 
Top