Enter Parameter Value on a subform

I'm confused.

I asked whether you were certain that the name of the subform control on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is "2ResponseFormC" and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the name of
the subform control may be different than the name of the form being used
as
a subform.

On the property sheet, it shows the source object is "2ResponseFormC" and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form B
shows
the question and related comments. Form C (continuous) allows for multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get "Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control on
[2ResponseFormC], a subform of B:

PARAMETERS [Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon; after
Long.
--

John W. Vinson [MVP]
.



.

Sorry. With 2ResponseFormA open, the property sheet for my subform control
shows the source object as "2ResponseFormB" and the name as "2ResponseFormB."

The subform within 2ResponseFormB has the source object and name of
"2ResponseFormC." My combo box that isn't populating correctly is on
2ResponseFormC.

"Douglas J. Steele" wrote:

I'm confused.

I asked whether you were certain that the name of the subform control on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is "2ResponseFormC" and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the name of
the subform control may be different than the name of the form being used
as
a subform.

On the property sheet, it shows the source object is "2ResponseFormC" and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form B
shows
the question and related comments. Form C (continuous) allows for multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get "Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control on
[2ResponseFormC], a subform of B:

PARAMETERS [Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon; after
Long.
--

John W. Vinson [MVP]
.



.



.

So what's the entire SQL of your query now?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Sorry. With 2ResponseFormA open, the property sheet for my subform control
shows the source object as "2ResponseFormB" and the name as
"2ResponseFormB."

The subform within 2ResponseFormB has the source object and name of
"2ResponseFormC." My combo box that isn't populating correctly is on
2ResponseFormC.

"Douglas J. Steele" wrote:

I'm confused.

I asked whether you were certain that the name of the subform control on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is "2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA
is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the name
of
the subform control may be different than the name of the form being
used
as
a subform.

On the property sheet, it shows the source object is "2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form B
shows
the question and related comments. Form C (continuous) allows for
multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get
"Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control on
[2ResponseFormC], a subform of B:

PARAMETERS
[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon; after
Long.
--

John W. Vinson [MVP]
.



.



.

PARAMETERS [Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID] IEEEDouble;
SELECT [3Responses].RId, [3Responses].Response, [3Responses].QuestID
FROM 3Responses
WHERE
((([3Responses].QuestID)=[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]))
ORDER BY [3Responses].RId;

(My [QNoID] field has a "double" field size.)

"Douglas J. Steele" wrote:

So what's the entire SQL of your query now?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Sorry. With 2ResponseFormA open, the property sheet for my subform control
shows the source object as "2ResponseFormB" and the name as
"2ResponseFormB."

The subform within 2ResponseFormB has the source object and name of
"2ResponseFormC." My combo box that isn't populating correctly is on
2ResponseFormC.

"Douglas J. Steele" wrote:

I'm confused.

I asked whether you were certain that the name of the subform control on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is "2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA
is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the name
of
the subform control may be different than the name of the form being
used
as
a subform.

On the property sheet, it shows the source object is "2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form B
shows
the question and related comments. Form C (continuous) allows for
multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get
"Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control on
[2ResponseFormC], a subform of B:

PARAMETERS
[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon; after
Long.
--

John W. Vinson [MVP]
.



.



.



.

I don't believe IEEDouble is a valid datatype in conjunction with the
PARAMETERS declaration.

See http://msdn.microsoft.com/en-us/library/bb208916.aspx for details on the
PARAMETERS declaration, and follow the link to
http://msdn.microsoft.com/en-us/library/bb208866.aspx for valid datatypes.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
PARAMETERS [Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
IEEEDouble;
SELECT [3Responses].RId, [3Responses].Response, [3Responses].QuestID
FROM 3Responses
WHERE
((([3Responses].QuestID)=[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]))
ORDER BY [3Responses].RId;

(My [QNoID] field has a "double" field size.)

"Douglas J. Steele" wrote:

So what's the entire SQL of your query now?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Sorry. With 2ResponseFormA open, the property sheet for my subform
control
shows the source object as "2ResponseFormB" and the name as
"2ResponseFormB."

The subform within 2ResponseFormB has the source object and name of
"2ResponseFormC." My combo box that isn't populating correctly is on
2ResponseFormC.

"Douglas J. Steele" wrote:

I'm confused.

I asked whether you were certain that the name of the subform control
on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is
"2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the
value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA
is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the
name
of
the subform control may be different than the name of the form
being
used
as
a subform.

On the property sheet, it shows the source object is
"2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form
B
shows
the question and related comments. Form C (continuous) allows for
multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the
Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get
"Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control
on
[2ResponseFormC], a subform of B:

PARAMETERS
[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon;
after
Long.
--

John W. Vinson [MVP]
.



.



.



.

The IEEDouble was automatically added when I used the "Parameter" feature in
the query design view.

Good news: I recreated all three forms, and their underlying queries, and
now it works. I only wish I could understand why it didn't work before!

Thanks for your help!

"Douglas J. Steele" wrote:

I don't believe IEEDouble is a valid datatype in conjunction with the
PARAMETERS declaration.

See http://msdn.microsoft.com/en-us/library/bb208916.aspx for details on the
PARAMETERS declaration, and follow the link to
http://msdn.microsoft.com/en-us/library/bb208866.aspx for valid datatypes.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
PARAMETERS [Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
IEEEDouble;
SELECT [3Responses].RId, [3Responses].Response, [3Responses].QuestID
FROM 3Responses
WHERE
((([3Responses].QuestID)=[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]))
ORDER BY [3Responses].RId;

(My [QNoID] field has a "double" field size.)

"Douglas J. Steele" wrote:

So what's the entire SQL of your query now?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Sorry. With 2ResponseFormA open, the property sheet for my subform
control
shows the source object as "2ResponseFormB" and the name as
"2ResponseFormB."

The subform within 2ResponseFormB has the source object and name of
"2ResponseFormC." My combo box that isn't populating correctly is on
2ResponseFormC.

"Douglas J. Steele" wrote:

I'm confused.

I asked whether you were certain that the name of the subform control
on
form 2ResponseFormA was 2ResponseFormB, and you answered

On the property sheet, it shows the source object is
"2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
See below.

"Douglas J. Steele" wrote:

The syntax you're using implies that you're trying to read the
value
contained in control QNoID on a subform of form 2ResponseFormA.

Yes, that's correct.

Are you
certain that the name of the subform control on form 2ResponseFormA
is,
in
fact, 2ResponseFormB? Depending on how you added the subform, the
name
of
the subform control may be different than the name of the form
being
used
as
a subform.

On the property sheet, it shows the source object is
"2ResponseFormC"
and
the Name is "2ResponseFormC," likewise for FormB.


I assume form 2ResponseFormA is open when you're running the query.
(Access
won't open the form for you.)

Yes, A is open. A is linked to B by "SurvID", B is linked to C by
"SurvRespID." Form A shows the basic information on the survey. Form
B
shows
the question and related comments. Form C (continuous) allows for
multiple
answers to the questions in Form B.

I can run the query separately and it works fine and pulls the
approrpriate
data. But when it is the row source for field [QNoID], I get the
Enter
parameter value message.


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Sara M" wrote in message
...
Even with the semicolon, I still get the "Enter Parameter Value"
message.

"John W. Vinson" wrote:

On Mon, 1 Feb 2010 07:15:01 -0800, Sara M

wrote:

When I change my SQL query to include your suggestion, I get
"Syntax
error in
PARAMETER clause."

My updated query, which is the row source for [RespNo] control
on
[2ResponseFormC], a subform of B:

PARAMETERS
[Forms]![2ResponseFormA]![2ResponseFormB].[Form]![QNoID]
Long

The only thing I can see is that there should be a semicolon;
after
Long.
--

John W. Vinson [MVP]
.



.



.



.



.