Grayed Out Text & combo box

[doran_doran]

1. Combo box 1 = "BillingStructure" should always be enable.
2. Combo box 2 = "Fee Waived" should be grayed out all the time only if the user pick "Fee Waived" from combo box 1.
3. if user pick "fee waived" from billingstructure combo box then fee waived combo box should be enable.
4. There are also some text associated with this, but i guess i can use the same method.

any help will be appreciated.

==================================
Private Sub BillingStructure_Change()
If Me!BillingStructure = "Fee Waived" Then
Me!Waiver_Reason.Enable = True
Me!Waiver_Reason.Locked = False
Else
Me!Waiver_Reason.Enable = False
Me!Waiver_Reason.Locked = True
End If
End Sub

 

[Fizzio]

Please only post the topic in one forum - do not duplicate the question across many fora as you may get conflicting or duplicate answers.

I have answered your question here

 

[mark curtis]

see attached

 

[doran_doran]

Access 97

Hi Mark,

Can you please convert the database to access 97 format?

Thanks.

Dianna

 

[mark curtis]

all u need to do is set the 2nd combo box enabled to no in the properties then on change event on the 1st combo box put the following:

if me.combo1.value="whatever?" then
me.combo2.enabled=true
else
me.combo2.enabled=false
end if

 

[doran_doran]

It Worked...

Thank you Mike, Awesome. I wish I had lots of brain like you guys. Thanks a million.

Dianna Jamil