On Click error

M

Matt Dawson

I currently have combo boxes with code similar to this below in the on click
section:
If Me![Quote Sent] = 0 Then '-- CheckBox is unchecked!
Me![Quote Not Sent].Enabled = True
Else '-- CheckBox is checked
Me![Quote Not Sent].Enabled = False

However, once one is selected, and the next record is searched for, it keeps
the previous selection and blanks out the other options when in reality, it
should automatically have one available and the other two greyed out. These
others would become enabled were the available box to beceom unchecked.

Any ideas as to how i overcome this?

Many Thanks,

Matt
 
Top