Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005
    Posts
    113

    Unanswered: Problem with subforms question

    Hello, I have a form with a subform. In a question I need to use a value from a textbox but I do not know how to enter the value in the question.

    Have tried Forms!frmMain!frmSub.txtDate but its wrong. Can anyone help me, please?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Forms![MyFormNameHere]![MySubformCONTROLNameHere]!MyTextBox
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Nov 2005
    Posts
    113
    Hello!
    It worked if I only run the query, but when I call the question in an Open Recordset (myQuestion) I may get the error "Too few parameters". Looks like it doesn't read the date in the subForm?

    It works if I write the date in the question.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You didn't mention a recordset in your original question. You're running into this:

    http://support.microsoft.com/default...b;en-us;209203
    Paul

  5. #5
    Join Date
    Nov 2005
    Posts
    113
    OH yes... Thanks Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •