option button on form load..

[Gary Liptrot]

Hi,
I have two option buttons (named 'op_denY' and 'op_denN') inside an option
group. On selecting 'op_denN' a pair of text boxes (intended for numbers
labelled 'min value' and 'max value') become disabled. I would like this to
be the "default" state for when form loads, i.e. with 'op_denN' clicked and
with the text boxes disabled. Is there any way to set the default state of
the option button to selected on form load? As currently both are fuzzy
greyed until one is clicked...

Also how would I write a query that filters for records with values in the
relevant field that are >= 'min value' and <= 'max value', and act as a
wildcard should either of the text boxes be left blank?

Regards,

Gary

 

[Gary Liptrot]

Noone able to help me?

 

[missinglinq via AccessMonster.com]

As to the option group question: When you create an Option Group, the first
dialog box that pops up asks for the lable captions you want displayed, the
second dialog box asks which button you want to use as your default. Since
yours shows both button's greyed out, I assume you skipped over this at the
time. To do it now, click on the outline of the frame (not the label part)
and go to the property box. Under the Data tab you'll see Default Value.
Enter the position of the button you want for your default here, i.e. if the
first button is Yes and the second button is No, and you want No to be the
default, enter a 2 here!

Hope this helps some!