Crosstab query

M

Muzila

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.
 
K

KARL DEWEY

Try this --
IIF(Forms!Part_Monthly!Combo36 Is Null, 1010, Forms!Part_Monthly!Combo36)
 
M

Muzila

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.
 
M

Muzila

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.
 
Top