Crosstab query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a combo box and a crosstab that has the parameter of that
combo box

Forms!Part_Monthly!Combo36

When i open the form, there is no parameter for the query to run so the
"enter parameter value" message box appears. Is there a way to enter the
intial value automatically. It will always be the value 1010.
 
This works after it is open, but becaue it is a crosstab, i had to put the
parameter in Query Paramter box. On the form open it still asks for it. If i
dont fill it out and hit ok, it works fine.
 
This works after it is open, but becaue it is a crosstab, i had to put the
parameter in Query Paramter box. On the form open it still asks for it. If i
dont fill it out and hit ok, it works fine.
 

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

Similar Threads

Default Parameter on form open 2
Multiple Parameter Crosstab query filter by form 1
Parameter Value in Crosstab Query 4
Parameter Queries in Crosstab Query 2
crosstab parameterized query 1
Crosstab 3
Query error, too few parameters 0
crosstab query with parameter query 5

Back
Top