Default Parameter on form open

[msmuzila]

i have a form that gets info from a query. The parameter in the query
is linked to the combo on the form

[Forms]![Part_Monthly]![Combo36]

I need a way to have a default value of 1010 when I open the form so
that it does not ask me for the parameter value.

Thanks
Matt

 

[fredg]

i have a form that gets info from a query. The parameter in the query
is linked to the combo on the form

[Forms]![Part_Monthly]![Combo36]

I need a way to have a default value of 1010 when I open the form so
that it does not ask me for the parameter value.

Thanks
Matt

Is the bound column of the combo box a Number datatype or Text?
If a Number, try:

IIf IsNull([forms]![Part_Monthly]![Combo36],1010,
[forms]![Part_Monthly]![Combo36]

If it's text use "1010" instead of 1010.

 

[msmuzila]

this is what i put in the crosstab criteria for the parameter

IIf(IsNull([forms]![Part_Monthly]![Combo36]),1010,[forms]![Part_Monthly]![Combo36])

when i open my form it still asks me for
[forms]![Part_Monthly]![Combo36]

when i hit cancel on this message box, it goes to the correct spot, so
is there a way to automatically cancel the parameter message box?