Enabling cells from list box

[quinnb]

Sorry i have tried and tried.
I have a form which will be used to send out reminders to people from either email, letter or both

On form load i have ADD1 ADD2 Town Postcode and email disabled
So have combo box - drop down with email, letter or both

If emAIL is selected then the cell enables
If Letter is enabled then the address fields enable
And if both is selected all fields enable

But i can get one of them to work i.e email but not all of them,
Please can someone help
thanks
Brian

 

[JHB]

..
Please can someone help

Sure, but we need to see the code you've.
Or better post your database with some sample data, zip it because you've post 10 post jet. + description where the problem code is.

 

[arnelgp]

you need to add code to your combobox's
AfterUpdate Event:

Private Sub yourCombo_AfterUpdate()
Select Case yourCombo
Case Is = "email"
	Me.cell.Enabled = True
	Me.Letter.Enabled = False
Case Is = "letter"
	Me.cell.Enabled = False
	Me.Letter.Enabled = True
Case Else
	Me.cell.Enabled = True
	Me.Letter.Enabled = True
End Select
End Sub