On May 28, 6:49 pm, "Steve" <no...@email.co mwrote:
I reread my reply to you and I made an error. Sorry!!
>
[forms]![nameofsubformco ntrolonmainform].form![cbostate]
>
Should Be:
>
[forms]!{NameOfMainFor m]![nameofsubformco ntrolonmainform].form![cbostate]
>
Also, the white box on your main form is a subform control. The name of that
control is what you want for [nameofsubformco ntrolonmainform] NOT the name
of your subform. The name of the subform control may or may not be the same
as the name of the subform.
>
Steve
>
"samdev" <la...@noblesof twaresolutions. comwrote in message
>
news:5adba9fa-a6e8-45c1-9a65-86f921d1049a@s5 0g2000hsb.googl egroups.com...
On May 28, 2:15 pm, "Steve" <no...@email.co mwrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Steve:
Thx - I have tried that it still doesn't work and it should from what
you have explained....I even changed the name of the subform in the
mainform and then went and updated the query and I'm still getting the
same parameter value box. I checked to make sure that I was clicking
on the subform box in the mainform by checking the title of the
property box and it reads Subform/subreport so still not sure what is
wrong.
>
Any other ideas.
>
Thx!- Hide quoted text -
>
- Show quoted text -
>
[forms]![nameofsubformco ntrolonmainform].form![cbostate]
>
Should Be:
>
[forms]!{NameOfMainFor m]![nameofsubformco ntrolonmainform].form![cbostate]
>
Also, the white box on your main form is a subform control. The name of that
control is what you want for [nameofsubformco ntrolonmainform] NOT the name
of your subform. The name of the subform control may or may not be the same
as the name of the subform.
>
Steve
>
"samdev" <la...@noblesof twaresolutions. comwrote in message
>
news:5adba9fa-a6e8-45c1-9a65-86f921d1049a@s5 0g2000hsb.googl egroups.com...
On May 28, 2:15 pm, "Steve" <no...@email.co mwrote:
>
>
>
>
>
When you open just the subform, the subform is a member of the database
forms collection so your [forms]![subform]![cbostate] notation correctly
identifies the subform. When you open the main form, the subform is a
member
of the main form's controls collection so your
[forms]![subform]![cbostate]
notation is not now correct because you are referencing the forms
collection
and not the main form's controls collection. The correct notation is
[forms]![nameofsubformco ntrolonmainform].form![cbostate]. To get
"nameofsubformc ontrolonmainfor m" , open the main form in design view,
select
the box that holds the subform, open Properties, go to the Other tab and
look at the Name property.
forms collection so your [forms]![subform]![cbostate] notation correctly
identifies the subform. When you open the main form, the subform is a
member
of the main form's controls collection so your
[forms]![subform]![cbostate]
notation is not now correct because you are referencing the forms
collection
and not the main form's controls collection. The correct notation is
[forms]![nameofsubformco ntrolonmainform].form![cbostate]. To get
"nameofsubformc ontrolonmainfor m" , open the main form in design view,
select
the box that holds the subform, open Properties, go to the Other tab and
look at the Name property.
Steve
"samdev" <la...@noblesof twaresolutions. comwrote in message
news:bd116f56-c6ae-44c2-99eb-d7e871e5d964@j2 2g2000hsf.googl egroups.com...
>I have created two combo boxes in a subform....
For example
1. Combo Box State
2. Combo Box City
3. When a state from the Combo Box State is selected, the City combo
box updates to reflect the State chosen by only showing cities in that
selected state.
4. When I open just the subform it works just fine but when I open the
Main form the contains the subform there are issues....
5. I can pick the State just fine but when I go to pick the City - a
box = an "Enter Parameter Value" opens...request ing the value for
[forms]![subform]![cbostate]. The city combo box is now blank.
2. Combo Box City
3. When a state from the Combo Box State is selected, the City combo
box updates to reflect the State chosen by only showing cities in that
selected state.
4. When I open just the subform it works just fine but when I open the
Main form the contains the subform there are issues....
5. I can pick the State just fine but when I go to pick the City - a
box = an "Enter Parameter Value" opens...request ing the value for
[forms]![subform]![cbostate]. The city combo box is now blank.
The row source for the city combo box is a query that contains the
city and the state field - the criteria for the state field [forms]!
[subform]![cbostate].
city and the state field - the criteria for the state field [forms]!
[subform]![cbostate].
Not sure why it works, when I do test via the subform but doesn't work
when when I go the main form that includes the subform....
when when I go the main form that includes the subform....
Any ideas would be very appreciated.
Thx!- Hide quoted text -
- Show quoted text -
Steve:
Thx - I have tried that it still doesn't work and it should from what
you have explained....I even changed the name of the subform in the
mainform and then went and updated the query and I'm still getting the
same parameter value box. I checked to make sure that I was clicking
on the subform box in the mainform by checking the title of the
property box and it reads Subform/subreport so still not sure what is
wrong.
>
Any other ideas.
>
Thx!- Hide quoted text -
>
- Show quoted text -
Leave a comment: