Parameter Query

J

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
 
B

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top