Check Conditional Formatting status of combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combobox on a form that is disabled based on data in another
combobox. I have a command button on the form to append the data to a table.
However, I need to be sure all of the Enabled fields have data or exit the
sub before appending the data. I have tried:

If IsNull(Me.Market) and Me.Market.Enabled = True Then

It seems that if conditional formatting disables the combobox, it doesn't
actually set the Enabled Property of the combobox so when using
Me.Market.Enabled it will always be true.

How do I accomplish this?
 
The safest way will be to use the same criteria in the first combo you are
using to enable the ComboBox Market

If IsNull(Me.Market) and Me.[Combo1Name] = 1 Then
 
I was hoping that I would not have to duplicate the Conditional Formatting
criteria. It sort of defeats the purpose of using Conditional Formatting
instead of using code in Afterupdate property of the comboboxes.

Thansk for the help, I off to add the criteria.

Ofer Cohen said:
The safest way will be to use the same criteria in the first combo you are
using to enable the ComboBox Market

If IsNull(Me.Market) and Me.[Combo1Name] = 1 Then


--
Good Luck
BS"D


RW said:
I have a combobox on a form that is disabled based on data in another
combobox. I have a command button on the form to append the data to a table.
However, I need to be sure all of the Enabled fields have data or exit the
sub before appending the data. I have tried:

If IsNull(Me.Market) and Me.Market.Enabled = True Then

It seems that if conditional formatting disables the combobox, it doesn't
actually set the Enabled Property of the combobox so when using
Me.Market.Enabled it will always be true.

How do I accomplish this?
Click to expand...
Click to expand...
 
Back
Top