Option Group Autofill

[Robbie Doo]

Is it possible to fill the Option Group automatically depending on a field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Beetle]

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select

 

[Robbie Doo]

Thank you Sean for the input. I forgot to mention that the Option Group is a
Subform feeding from a different Table. This method gave me an error.

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey

Is it possible to fill the Option Group automatically depending on a field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Beetle]

I forgot to mention that the Option Group is a Subform

Not following you. An Option Group is not the same thing as a Subform. Did
you mean that the Option Group is placed within a subform? If so, you would
modify as follows;

Select Case Me![YourDaysControl]
Case < 16
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 1
Case < 26
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 3
End Select

--
_________

Sean Bailey

Thank you Sean for the input. I forgot to mention that the Option Group is a
Subform feeding from a different Table. This method gave me an error.

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey

Is it possible to fill the Option Group automatically depending on a field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Damon Heron]

Wouldn't this Select Case always be Option 3? If the range is 16 to 25,
better to use Case >15 and <26 or what ever the syntax is.

Damon

I forgot to mention that the Option Group is a Subform

Not following you. An Option Group is not the same thing as a Subform. Did
you mean that the Option Group is placed within a subform? If so, you
would
modify as follows;

Select Case Me![YourDaysControl]
Case < 16
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 1
Case < 26
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 3
End Select

--
_________

Sean Bailey

Thank you Sean for the input. I forgot to mention that the Option Group
is a
Subform feeding from a different Table. This method gave me an error.

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey


:

Is it possible to fill the Option Group automatically depending on a
field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less
than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Damon Heron]

Ooops! I am wrong. Select Case always ends after selecting the correct
response.
Brain n-o-t w-o-r-k-i-n-g t-o-d-a-y.....
Damon

Wouldn't this Select Case always be Option 3? If the range is 16 to 25,
better to use Case >15 and <26 or what ever the syntax is.

Damon

I forgot to mention that the Option Group is a Subform

Not following you. An Option Group is not the same thing as a Subform.
Did
you mean that the Option Group is placed within a subform? If so, you
would
modify as follows;

Select Case Me![YourDaysControl]
Case < 16
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 1
Case < 26
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 3
End Select

--
_________

Sean Bailey

Thank you Sean for the input. I forgot to mention that the Option Group
is a
Subform feeding from a different Table. This method gave me an error.

:

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey


:

Is it possible to fill the Option Group automatically depending on a
field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less
than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Linq Adams via AccessMonster.com]

Select Case executes the first case that is satisfied, so Option 3 will only
be selected if YourDaysControl] => 26 AND YourDaysControl] < 41

 

[Linq Adams via AccessMonster.com]

"Brain n-o-t w-o-r-k-i-n-g t-o-d-a-y....."

Don't you hate when that happens! There needs to be an interlock mechanism so
that the fingers can't type faster than the brain can think!

;0)>

 

[Beetle]

No because it exits the statement as soon as a condition is met. By the
time it gets to the second case we already know the value is > 15,
otherwise it would have exited at the first case. Ditto for the third case.

Not that there is anything wrong with doing it as you suggest. Maybe I'm
just lazy and like to type as little as possible.
--
_________

Sean Bailey

Wouldn't this Select Case always be Option 3? If the range is 16 to 25,
better to use Case >15 and <26 or what ever the syntax is.

Damon

I forgot to mention that the Option Group is a Subform

Not following you. An Option Group is not the same thing as a Subform. Did
you mean that the Option Group is placed within a subform? If so, you
would
modify as follows;

Select Case Me![YourDaysControl]
Case < 16
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 1
Case < 26
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 3
End Select

--
_________

Sean Bailey

Thank you Sean for the input. I forgot to mention that the Option Group
is a
Subform feeding from a different Table. This method gave me an error.

:

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey


:

Is it possible to fill the Option Group automatically depending on a
field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less
than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,

 

[Robbie Doo]

Thank you Sean. Everything worked perfectly.

No because it exits the statement as soon as a condition is met. By the
time it gets to the second case we already know the value is > 15,
otherwise it would have exited at the first case. Ditto for the third case.

Not that there is anything wrong with doing it as you suggest. Maybe I'm
just lazy and like to type as little as possible.
--
_________

Sean Bailey

Wouldn't this Select Case always be Option 3? If the range is 16 to 25,
better to use Case >15 and <26 or what ever the syntax is.

Damon

I forgot to mention that the Option Group is a Subform

Not following you. An Option Group is not the same thing as a Subform. Did
you mean that the Option Group is placed within a subform? If so, you
would
modify as follows;

Select Case Me![YourDaysControl]
Case < 16
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 1
Case < 26
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![NameOfYourSubformControl].Form![YourOptionGroup] = 3
End Select

--
_________

Sean Bailey


:

Thank you Sean for the input. I forgot to mention that the Option Group
is a
Subform feeding from a different Table. This method gave me an error.

:

You can use some code like the following in the Current event of your
form and the After Update event of your "days" control;

Select Case Me![YourDaysControl]
Case < 16
Me![YourOptionGroup] = 1
Case < 26
Me![YourOptionGroup] = 2
Case < 41 (or whatever)
Me![YourOptionGroup] = 3
End Select
--
_________

Sean Bailey


:

Is it possible to fill the Option Group automatically depending on a
field
value on the Main form?
I want my Option to mark the 1st radio button when the days are less
than 15
or the 2nd button if the days are between 16-25 and so on...

Thank you,