Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Unanswered: Import fields to unbound text boxes

    To streamline data entry I have the following code to import fields from bound text boxes, to unbound ones on another form. However when the import button is clicked, no data is inputted in the unbound text boxes. Am I missing something? The Client Entry form contains the unbound boxes.

    Forms![Client Entry]![txtParentNumber] = Forms![Client Database]![Parent Number]

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you need to assign the value OR text PROPERTY, NOT the control itself
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2007
    Posts
    214
    Do you mean for example ...

    Forms![Client Entry]!txtParentNumber.text = Forms![Client Database]!Parent_Number.text

    I tried this no avail. Just curious on any clarifications. Thanks!

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Are both forms open when you click the Import button?

  5. #5
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Moreover, if you use the Text property, the concerned textbox control must have the focus.
    Have a nice day!

Posting Permissions

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