If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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] . . |
#12
|
|||
|
|||
Enter Parameter Value on a subform
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] . . . |
#13
|
|||
|
|||
Enter Parameter Value on a subform
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] . . . |
#14
|
|||
|
|||
Enter Parameter Value on a subform
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] . . . . |
#15
|
|||
|
|||
Enter Parameter Value on a subform
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] . . . . |
#16
|
|||
|
|||
Enter Parameter Value on a subform
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] . . . . . |
|
Thread Tools | |
Display Modes | |
|
|