Value List Issue

[burrina]

I can't get my code to work. I have tried every event. What am I missing?


combo named SinMar
it is a Value List row source type bound column 1
column widths = 0";0.9056"
column count = 2
rowsource = 1;"Single";2;"Married";3;"N/A"

If Me.txtemporcon = 3 Then ' txtemporcon is a textbox with control source set to field on main form. EmpOrConType
rowsource can only = N/A

[burrina]

I forgot to mention that this is a subform but that should not make a difference.
frmEmployees is main form.
frmSinMarSub is subform.

[burrina]

I changed them from Value list to use a table(s) instead.
Still no solution other than a msgbox

[HansV]

So:
You have a text box txtemporcon on the main form frmEmployees. If its value is 3 then the combo box SinMar on the subform frmSinMarSub should display only N/A. Otherwise, it should display all three options.
Is that correct?

[burrina]

I have tried everything and finally used a Label to display a warning.

[burrina]

Many Thanks for taking a look at this but I have scrapped it.
Too difficult for you to make sense of without seeing it.
Not going to happen here.
Thanks Again.