Condition on Form Makes Combo Visible on Another

[KLahvic01]

I have a question. Is it possible to code a combobox to be visible on one form based on a condition of a checkbox on a seperate form?

What I have is a main form (frmMain) and a Customer form (frmCustomers), what I want to do is have a checkbox on the customers form drive whether or not the combo box on the main form is active. The caveat is, each customer record may have a different condition on the checkbox. There is a combo on my main form to select the customer to apply to the sale.

I figured an If then statement would work, but then I am not sure how to code how to differentiate when a different customer is selected. Something like this on the oncurrent event of the main form:

If forms!frmCustomers.chkmaxdisc = True Then
me.cbousedisc.visible = true
else me.cbousedisc.visible = false
end if

I know this is rudamentary, but it isnt working for this circumstance. I hope someone can point me in the right direction.

Thanks in advance!

KJ

 

[John Big Booty]

What event do you have this code in?