default value

[toddbingham]

Running a query that is asking to inout a vaule ( [Enter O-OPen or C-Closed] )

When That question appears, how can I have it default a vaule in there but also give the option to change it?

Thanks.

 

[Mile-O]

Don't use a parameter - from what you currently have someone can easily type in Y and expect a result.

Use a combo on a form - it's easier to reference and you can restrict it in any way you please.

 

[toddbingham]

Well, I do want them to expect results from entering either choice. It is just one choice will be used 90% of the time. The other will be used, but not as often. I think this would be the simplest way to do it since the users are very limited. Giving them a drop down box would totally confuse them. Can I default a value in there?

 

[Mile-O]

Not in a parameter box.

But, I'm guessing you have a button they click (or something) which opens this query.

If you put a combobox with Open and Closed as it's Value List beside this button then ran the query with the criteria being

[Forms]![MyForm]![MyCombo]

instead of

[Enter O-OPen or C-Closed]

then you can set a default, check if there's nothing entered, even determining beforehand if the query will return any records.

 

[toddbingham]

Worked, thanks.