enable field based on another

[cdoyle]

Hi,

I have my main form, with a continuous sub form.

On the sub form, I have a dropdown. What I'm trying to do is, if they select a certain value from the dropdown, another field in this form becomes enabled.

I tried this on the afterupdate of my combo, and it works but it enables the field for all the records.

Is there a way to make something like this work on a continuous form?

If Me!cbo_license_count = "2" Then
   Me.number_license_needed.Enabled = True
End If

 

[pbaldy]

Conditional Formatting would be the simplest way (Format/Conditional Formatting).

 

[cdoyle]

What would I put in the conditional field screen?

Would I select the field that I want to be enabled/disabled and then put something in the expression field?

 

[pbaldy]

Yes; and use "Expression Is" rather than "Field Value Is", which lets you refer to a different field.

 

[suepowell]

HI,

I have a similar problem in that I want a button to be visible if a filed meets a certain condition, but not if it doesn't.

The condition is that the field exists in another table which I test in code using Dlookup. I could set a flag in the table the form is based on if that makes it easier.

Conditional formatting doesn't seem to be available for command buttons, is there a way round this?

Thanks in anticipation.

Sue