Value List Issue

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Value List Issue

Post by 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

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Value List Issue

Post by burrina »

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

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Value List Issue

Post by burrina »

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

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Value List Issue

Post by 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?
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Value List Issue

Post by burrina »

I have tried everything and finally used a Label to display a warning.
You do not have the required permissions to view the files attached to this post.

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Value List Issue

Post by 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.