activating options groups

[hotaemin]

i have a form with a subform in datasheet view.
each line, when double-clicked, opens another form with 3 option
groups, i.e. name, age, male/female so to speak...
depends on the line, one or two or all three option groups are to be
activated.
each line has a field that holds combination of number 1 or 2 or 3 in
any order.
so when the line with number 123 is double-clicked, all groups in the
new form are activated.
if only 1 is or 2 is entered, corresponding group is activated when
other groups are shaded.
please help. thanks.

 

[Someone]

I really don't understand what you're trying to explain.

M

 

[John Vinson]

i have a form with a subform in datasheet view.
each line, when double-clicked, opens another form with 3 option
groups, i.e. name, age, male/female so to speak...
depends on the line, one or two or all three option groups are to be
activated.
each line has a field that holds combination of number 1 or 2 or 3 in
any order.
so when the line with number 123 is double-clicked, all groups in the
new form are activated.
if only 1 is or 2 is entered, corresponding group is activated when
other groups are shaded.
please help. thanks.

This seems like a VERY complicated and user-hostile approach... or
else I'm completely misunderstanding it. What's the subform's
Recordsource? What's the popup form's Recordsource? What are you
actually trying to accomplish? Storing three different values in a
single field is Bad Design right off the bat, for one thing; what's to
keep a user from entering 987 or 444444444444 into the field, if it's
updateable, or why should these three values be jammed into one field,
if it's not?

My guess is that (if you have Access2002 or later) you can use
Conditional Formatting to enable or disable controls right on the
continuous subform, much more easily.

John W. Vinson[MVP]

 

[hotaemin]

i see. maybe i should look into the conditional formatting. thank you.