By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

Option-button-choice enables fields

P: n/a
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and female)
After selecting option button 'Male' (fields2) the questions for female (
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never used
code.
Can it be done without code? How?

Thanks,

Filip
Aug 11 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Select Case Me.Gender

Case "Male"
Me.Question1ForFemale.Locked = True
Me.Question2ForFemale.Locked = True
Me.Question3ForFemale.Locked = True
Me.Question1ForMale.Locked = False
Me.Question2ForMale.Locked = False
Me.Question3ForMale.Locked = False
Case "Female"
Me.Question1ForFemale.Locked = False
Me.Question2ForFemale.Locked = False
Me.Question3ForFemale.Locked = False
Me.Question1ForMale.Locked = True
Me.Question2ForMale.Locked = True
Me.Question3ForMale.Locked = True
End Select

Hope that helps!


Filips Benoit wrote:
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and female)
After selecting option button 'Male' (fields2) the questions for female (
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never used
code.
Can it be done without code? How?

Thanks,

Filip
Aug 11 '06 #2

P: n/a
Thanks, BUT it was an exam-question for a friend and they never used code.
?? Can it be done without code? How?

Filip

"Jeff L" <jl*******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Select Case Me.Gender

Case "Male"
Me.Question1ForFemale.Locked = True
Me.Question2ForFemale.Locked = True
Me.Question3ForFemale.Locked = True
Me.Question1ForMale.Locked = False
Me.Question2ForMale.Locked = False
Me.Question3ForMale.Locked = False
Case "Female"
Me.Question1ForFemale.Locked = False
Me.Question2ForFemale.Locked = False
Me.Question3ForFemale.Locked = False
Me.Question1ForMale.Locked = True
Me.Question2ForMale.Locked = True
Me.Question3ForMale.Locked = True
End Select

Hope that helps!


Filips Benoit wrote:
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and
female)
After selecting option button 'Male' (fields2) the questions for female
(
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never
used
code.
Can it be done without code? How?

Thanks,

Filip

Aug 11 '06 #3

P: n/a
I'm sorry, I misread your post. To the best of my knowledge, I believe
some code will be necessary to accomplish this.

Filips Benoit wrote:
Thanks, BUT it was an exam-question for a friend and they never used code.
?? Can it be done without code? How?

Filip

"Jeff L" <jl*******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Select Case Me.Gender

Case "Male"
Me.Question1ForFemale.Locked = True
Me.Question2ForFemale.Locked = True
Me.Question3ForFemale.Locked = True
Me.Question1ForMale.Locked = False
Me.Question2ForMale.Locked = False
Me.Question3ForMale.Locked = False
Case "Female"
Me.Question1ForFemale.Locked = False
Me.Question2ForFemale.Locked = False
Me.Question3ForFemale.Locked = False
Me.Question1ForMale.Locked = True
Me.Question2ForMale.Locked = True
Me.Question3ForMale.Locked = True
End Select

Hope that helps!


Filips Benoit wrote:
Dear All,
>
Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale
>
A form ( source = Table1) having all fields (questions for male and
female)
After selecting option button 'Male' (fields2) the questions for female
(
fields6>8) should be enabled, locked.
>
I should do it using code, BUT it was an exam-question and they never
used
code.
Can it be done without code? How?
>
Thanks,
>
Filip
Aug 11 '06 #4

P: n/a
I have never found a way to do this without some code.
Filips Benoit wrote:
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and female)
After selecting option button 'Male' (fields2) the questions for female (
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never used
code.
Can it be done without code? How?

Thanks,

Filip
Aug 11 '06 #5

P: n/a
I have never found a way to do this without some code.
Filips Benoit wrote:
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and female)
After selecting option button 'Male' (fields2) the questions for female (
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never used
code.
Can it be done without code? How?

Thanks,

Filip
Aug 11 '06 #6

P: n/a
I don't do "macro answers," but it can likely be accomplished with a macro
with a condition.

Larry Linson
Microsoft Access MVP

"Filips Benoit" <be***********@pandora.bewrote in message
news:ih********************@phobos.telenet-ops.be...
Thanks, BUT it was an exam-question for a friend and they never used
code.
?? Can it be done without code? How?

Filip

"Jeff L" <jl*******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
>Select Case Me.Gender

Case "Male"
Me.Question1ForFemale.Locked = True
Me.Question2ForFemale.Locked = True
Me.Question3ForFemale.Locked = True
Me.Question1ForMale.Locked = False
Me.Question2ForMale.Locked = False
Me.Question3ForMale.Locked = False
Case "Female"
Me.Question1ForFemale.Locked = False
Me.Question2ForFemale.Locked = False
Me.Question3ForFemale.Locked = False
Me.Question1ForMale.Locked = True
Me.Question2ForMale.Locked = True
Me.Question3ForMale.Locked = True
End Select

Hope that helps!


Filips Benoit wrote:
Dear All,

Table1
Field1: Name
Field2: Gender
Field3:Question1ForMale
Field4:Question2ForMale
Field5:Question3ForMale
Field6:Question1ForFemale
Field7:Question2ForFemale
Field8:Question3ForFemale

A form ( source = Table1) having all fields (questions for male and
female)
After selecting option button 'Male' (fields2) the questions for female
(
fields6>8) should be enabled, locked.

I should do it using code, BUT it was an exam-question and they never
used
code.
Can it be done without code? How?

Thanks,

Filip


Aug 11 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.