Main form and subform

Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a combo
box) and in this field, among other listings I have rate, plans, co-pay and
accumulations. In one of my Tabs called Routing, one of my fields is called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

I will assume that your Work Category combobox is based on a table that
looks like:
TblWorkCategory
WorkCategoryID
WorkCategory
and your combobox has its Bound Column property set to 1 and Column Width
property set to 0;1.5.

To do what you want ...........
1. Go to design view and set the Enabled property of Claim Monitoring
field to False
2. Put the following code in the AfterUpdate event of your combobox:
Select Case Me![Work Category].Column(2)
Case "Rate" Or "Plans" Or "Co-pay" Or "Accumulation"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

Steve



"Beeyen" wrote in message
...
Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a
combo
box) and in this field, among other listings I have rate, plans, co-pay
and
accumulations. In one of my Tabs called Routing, one of my fields is
called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

Good Day Steve,

Thank you for the assistance. You are correct with the parameters of the
combo box and I have entered the code as you suggested (as is below):

Private Sub Work_Category_AfterUpdate()
Select Case Me![Work Category].Column(2)
Case "rates" Or "plans" Or "co-pay" Or "accumulations"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

End Sub

Yet, I received a debugging runtime error 13, type mismatch message, which
stops at: Case "rates" Or "plans" Or "co-pay" Or "accumulations"

Any ideas?

"Steve" wrote:

I will assume that your Work Category combobox is based on a table that
looks like:
TblWorkCategory
WorkCategoryID
WorkCategory
and your combobox has its Bound Column property set to 1 and Column Width
property set to 0;1.5.

To do what you want ...........
1. Go to design view and set the Enabled property of Claim Monitoring
field to False
2. Put the following code in the AfterUpdate event of your combobox:
Select Case Me![Work Category].Column(2)
Case "Rate" Or "Plans" Or "Co-pay" Or "Accumulation"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

Steve



"Beeyen" wrote in message
...
Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a
combo
box) and in this field, among other listings I have rate, plans, co-pay
and
accumulations. In one of my Tabs called Routing, one of my fields is
called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

Two suggestions
1: replace the "or"s with commas so that the line is
Case "rates", "plans", "co-pay", "accumulations"
2: Avoid any offers by steve to help. He is a known troll who offers
questionable services for questionable fees

John... Visio MVP

"Beeyen" wrote in message
...
Good Day Steve,

Thank you for the assistance. You are correct with the parameters of the
combo box and I have entered the code as you suggested (as is below):

Private Sub Work_Category_AfterUpdate()
Select Case Me![Work Category].Column(2)
Case "rates" Or "plans" Or "co-pay" Or "accumulations"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

End Sub

Yet, I received a debugging runtime error 13, type mismatch message, which
stops at: Case "rates" Or "plans" Or "co-pay" Or "accumulations"

Any ideas?

"Steve" wrote:

I will assume that your Work Category combobox is based on a table that
looks like:
TblWorkCategory
WorkCategoryID
WorkCategory
and your combobox has its Bound Column property set to 1 and Column Width
property set to 0;1.5.

To do what you want ...........
1. Go to design view and set the Enabled property of Claim Monitoring
field to False
2. Put the following code in the AfterUpdate event of your combobox:
Select Case Me![Work Category].Column(2)
Case "Rate" Or "Plans" Or "Co-pay" Or "Accumulation"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

Steve



"Beeyen" wrote in message
...
Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a
combo
box) and in this field, among other listings I have rate, plans, co-pay
and
accumulations. In one of my Tabs called Routing, one of my fields is
called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work
Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

Good Day John,

Thanks for the heads up. I am an Access medium beginner (self – taught) and
am working on a database with a number of conditions and I have lots of
questions. So it has been good to seek the assistance of the community. I
was thinking to myself with so much more corruption (mostly due to the
current economy) it is good to be able to raise a question and have so many
united for an answer. My second job is building computers; I do it for the
experience. I have always shared my knowledge and assistance daily; in return
knowing others are not being taken advantage of and can enjoy the technology
before them.

Thanks again

"John... Visio MVP" wrote:

Two suggestions
1: replace the "or"s with commas so that the line is
Case "rates", "plans", "co-pay", "accumulations"
2: Avoid any offers by steve to help. He is a known troll who offers
questionable services for questionable fees

John... Visio MVP

"Beeyen" wrote in message
...
Good Day Steve,

Thank you for the assistance. You are correct with the parameters of the
combo box and I have entered the code as you suggested (as is below):

Private Sub Work_Category_AfterUpdate()
Select Case Me![Work Category].Column(2)
Case "rates" Or "plans" Or "co-pay" Or "accumulations"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

End Sub

Yet, I received a debugging runtime error 13, type mismatch message, which
stops at: Case "rates" Or "plans" Or "co-pay" Or "accumulations"

Any ideas?

"Steve" wrote:

I will assume that your Work Category combobox is based on a table that
looks like:
TblWorkCategory
WorkCategoryID
WorkCategory
and your combobox has its Bound Column property set to 1 and Column Width
property set to 0;1.5.

To do what you want ...........
1. Go to design view and set the Enabled property of Claim Monitoring
field to False
2. Put the following code in the AfterUpdate event of your combobox:
Select Case Me![Work Category].Column(2)
Case "Rate" Or "Plans" Or "Co-pay" Or "Accumulation"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

Steve



"Beeyen" wrote in message
...
Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a
combo
box) and in this field, among other listings I have rate, plans, co-pay
and
accumulations. In one of my Tabs called Routing, one of my fields is
called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work
Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

Good Day John
Thanks for the assistance, the commas worked. Now I received another
Run-time 2465, The mainform can't find the field 'Claims Monitoring' referred
to in your expression.

Could it be that the coding does not reference that the 'Claims Monitoring'
field located in a Tab Subform called Routing?

rivate Sub WorkCategory_AfterUpdate()
Select Case Me![WorkCategory].Column(2)
Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False

"Beeyen" wrote:

Good Day John,

Thanks for the heads up. I am an Access medium beginner (self – taught) and
am working on a database with a number of conditions and I have lots of
questions. So it has been good to seek the assistance of the community. I
was thinking to myself with so much more corruption (mostly due to the
current economy) it is good to be able to raise a question and have so many
united for an answer. My second job is building computers; I do it for the
experience. I have always shared my knowledge and assistance daily; in return
knowing others are not being taken advantage of and can enjoy the technology
before them.

Thanks again

"John... Visio MVP" wrote:

Two suggestions
1: replace the "or"s with commas so that the line is
Case "rates", "plans", "co-pay", "accumulations"
2: Avoid any offers by steve to help. He is a known troll who offers
questionable services for questionable fees

John... Visio MVP

"Beeyen" wrote in message
...
Good Day Steve,

Thank you for the assistance. You are correct with the parameters of the
combo box and I have entered the code as you suggested (as is below):

Private Sub Work_Category_AfterUpdate()
Select Case Me![Work Category].Column(2)
Case "rates" Or "plans" Or "co-pay" Or "accumulations"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

End Sub

Yet, I received a debugging runtime error 13, type mismatch message, which
stops at: Case "rates" Or "plans" Or "co-pay" Or "accumulations"

Any ideas?

"Steve" wrote:

I will assume that your Work Category combobox is based on a table that
looks like:
TblWorkCategory
WorkCategoryID
WorkCategory
and your combobox has its Bound Column property set to 1 and Column Width
property set to 0;1.5.

To do what you want ...........
1. Go to design view and set the Enabled property of Claim Monitoring
field to False
2. Put the following code in the AfterUpdate event of your combobox:
Select Case Me![Work Category].Column(2)
Case "Rate" Or "Plans" Or "Co-pay" Or "Accumulation"
Me![Claims Monitoring].Enabled = True
Case Else
Me![Claims Monitoring].Enabled = False
End Select

Steve



"Beeyen" wrote in message
...
Good Day,

Let me try this one again; I have a master form with several Tabs and
Subforms. In the master form there is a field called Work Category (a
combo
box) and in this field, among other listings I have rate, plans, co-pay
and
accumulations. In one of my Tabs called Routing, one of my fields is
called
Claims Monitoring

If rate, plans, co-pay or accumulation is selection in the Work
Category
field of the Master form I would like to see the Claim Monitoring field
populated with which every the selection is, otherwise the field is
grayed-out.

Can this be done?

Thanks in advance

On Sun, 12 Apr 2009 09:21:01 -0700, Beeyen
wrote:

Good Day John
Thanks for the assistance, the commas worked. Now I received another
Run-time 2465, The mainform can't find the field 'Claims Monitoring' referred
to in your expression.

Could it be that the coding does not reference that the 'Claims Monitoring'
field located in a Tab Subform called Routing?


Yes. A Subform is another form; Me! refers to the form on which the code
exists (the main form in this case). The syntax for referencing a subform is
peculiar: you need to use the name *of the Subform control* (which may be
different than the name of the Form object within that control). Try

Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!Routing.Form![Claims Monitoring].Enabled = True
Case Else
Me!Routing.Form![Claims Monitoring].Enabled = False

This means "look in the Subform control on this form (Me) named Routing; look
at the Form object within that Subform control (Form!); find the control named
[Claims Monitoring] and enable/disable it.
--

John W. Vinson [MVP]

John, thanks for the assist.

John... Visio MVP
"John W. Vinson" wrote in message
...
On Sun, 12 Apr 2009 09:21:01 -0700, Beeyen

wrote:

Good Day John
Thanks for the assistance, the commas worked. Now I received another
Run-time 2465, The mainform can't find the field 'Claims Monitoring'
referred
to in your expression.

Could it be that the coding does not reference that the 'Claims
Monitoring'
field located in a Tab Subform called Routing?


Yes. A Subform is another form; Me! refers to the form on which the code
exists (the main form in this case). The syntax for referencing a subform
is
peculiar: you need to use the name *of the Subform control* (which may be
different than the name of the Form object within that control). Try

Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!Routing.Form![Claims Monitoring].Enabled = True
Case Else
Me!Routing.Form![Claims Monitoring].Enabled = False

This means "look in the Subform control on this form (Me) named Routing;
look
at the Form object within that Subform control (Form!); find the control
named
[Claims Monitoring] and enable/disable it.
--

John W. Vinson [MVP]

Good Day Gentlemen,

I have tried the solution below, which makes perfect sense, but I continue
to received a runtime error 438 (Object doesn't support this property or
method). The code is included below. Any thought of what I might be doing
wrong?

Mainform = frmWorkload Information Tracker
Mainform field = WorkCategory
Subform = frmRouting
Subform field = ClaimMonitoring

Private Sub WorkCategory_AfterUpdate()
Select Case Me.WorkCategory.Column(2)
Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!frmRouting.Form![ClaimMonitoring].Enabled = True

Case Else
Me!frmRouting.Form![ClaimMonitoring].Enabled = False

End Select

End Sub

Thank you

"John... Visio MVP" wrote:

John, thanks for the assist.

John... Visio MVP
"John W. Vinson" wrote in message
...
On Sun, 12 Apr 2009 09:21:01 -0700, Beeyen

wrote:

Good Day John
Thanks for the assistance, the commas worked. Now I received another
Run-time 2465, The mainform can't find the field 'Claims Monitoring'
referred
to in your expression.

Could it be that the coding does not reference that the 'Claims
Monitoring'
field located in a Tab Subform called Routing?


Yes. A Subform is another form; Me! refers to the form on which the code
exists (the main form in this case). The syntax for referencing a subform
is
peculiar: you need to use the name *of the Subform control* (which may be
different than the name of the Form object within that control). Try

Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!Routing.Form![Claims Monitoring].Enabled = True
Case Else
Me!Routing.Form![Claims Monitoring].Enabled = False

This means "look in the Subform control on this form (Me) named Routing;
look
at the Form object within that Subform control (Form!); find the control
named
[Claims Monitoring] and enable/disable it.
--

John W. Vinson [MVP]

did you verify the name of the subform control *within the mainform*? a
subform is a form that is "housed" or "contained" in a control inside of
another form. that "container" control is the subform control within the
mainform. in your code, you need to make sure you're referring to the name
of the container control - NOT the name of the subform form object as it
shows in the database window. to get the correct name: open the mainform in
Design view. within the mainform, click *once* on the subform to select it.
in the Properties box, click on the Other tab and look at the Name property.
that's the name of the subform control within the mainform. for example,
let's say the above steps showed the subform control name as ChildMonitor.
assuming that the code is running in the mainform, the reference would be

Me!ChildMonitor.Form!ClaimMonitoring.Enabled = True

hth


"Beeyen" wrote in message
...
Good Day Gentlemen,

I have tried the solution below, which makes perfect sense, but I continue
to received a runtime error 438 (Object doesn't support this property or
method). The code is included below. Any thought of what I might be
doing
wrong?

Mainform = frmWorkload Information Tracker
Mainform field = WorkCategory
Subform = frmRouting
Subform field = ClaimMonitoring

Private Sub WorkCategory_AfterUpdate()
Select Case Me.WorkCategory.Column(2)
Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!frmRouting.Form![ClaimMonitoring].Enabled = True

Case Else
Me!frmRouting.Form![ClaimMonitoring].Enabled = False

End Select

End Sub

Thank you

"John... Visio MVP" wrote:

John, thanks for the assist.

John... Visio MVP
"John W. Vinson" wrote in message
...
On Sun, 12 Apr 2009 09:21:01 -0700, Beeyen

wrote:

Good Day John
Thanks for the assistance, the commas worked. Now I received another
Run-time 2465, The mainform can't find the field 'Claims Monitoring'
referred
to in your expression.

Could it be that the coding does not reference that the 'Claims
Monitoring'
field located in a Tab Subform called Routing?


Yes. A Subform is another form; Me! refers to the form on which the
code
exists (the main form in this case). The syntax for referencing a
subform
is
peculiar: you need to use the name *of the Subform control* (which may
be
different than the name of the Form object within that control). Try

Case "RATES", "PLANS", "CO-PAY", "ACCUMULATIONS"
Me!Routing.Form![Claims Monitoring].Enabled = True
Case Else
Me!Routing.Form![Claims Monitoring].Enabled = False

This means "look in the Subform control on this form (Me) named
Routing;
look
at the Form object within that Subform control (Form!); find the
control
named
[Claims Monitoring] and enable/disable it.
--

John W. Vinson [MVP]