Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    42

    Unanswered: assigning record source to unbound objects

    I need to open an unbound FORM from another form i.e. from form1 to open form2 and assign the form record source and (2) how about the unbound controls as well how to assign control source to a text box accordingly

    thanks in advance

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    ]For a detailed explanation search in Access help for the RecordSource property of the Form object and for the ControlSource property of the TextBox object.

    Basically it consists in assigning values to those properties for the concerned objects; Ex.
    Code:
    Forms("Form1").RecordSource = "Query_Form1"
    Forms("Form1").Controls("TextBox1").ControlSource = "Field1"
    Have a nice day!

  3. #3
    Join Date
    Mar 2011
    Posts
    42
    Just fine thanks dear

  4. #4
    Join Date
    Mar 2011
    Posts
    42
    Dear Sinndho,
    would you please help me in this article :
    http://www.dbforums.com/microsoft-ac...-vba-code.html

Posting Permissions

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