Parameter Query

[Jorge Ribeiro]

Hello

I've a query (eg QwCustomerDetails) with a parameter CustomerId.
This query feeds a subForm inside a main Form.

When I run the main form i wanted to set that parameter to a value to prevent
access to launch the parameter input dialog box.

I tried to set that parameter in OnLoad event of Main form but it seems to
run
always after access displays the input dialog.

How can I accomplished this?

best regards

Jorge

 

[bhicks11 via AccessMonster.com]

Instead of making it a parameter query, just set the value of the field in
the query to a control on the form. You can set the value of the control.
If you don't want the user seeing it, set it's visible property to NO.

Bonnie
http://www.dataplus-svc.com

 

[Jorge Ribeiro]

Tanx

Can you tell me how can i, instead of fetching the parameter value from a
control
fetching it from Form's Tag property? Or, better, from a property in form's
code.

regards

Jorge