Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    89

    Unanswered: Column(#) on a subform

    Hi i hope that someone can help me.
    Im looking to find a way to update a Value from an subform to update other textboxes with the 2e and 3e collumn.

    Normaly on the same form the code would be like: me!txtTextBox1 = me!cboComboBox1.column(1)
    if tried to use:
    [forms]![frmMAINFORM]![frmSUBFORM].[txtTextBox1] = [forms]![frmMAINFORM]![frmSUBFORM].[txtTextBox1].column(1)
    Or
    [forms]![frmMAINFORM]![frmSUBFORM].Form![txtTextBox1]
    [forms]![frmMAINFORM]![frmSUBFORM].Form![txtTextBox1] = [forms]![frmMAINFORM]![frmSUBFORM].Form![txtTextBox1].column(1)


    But thos both return the error 438.

    The thing i want to achive is to run the: me!txtTextBox1 = me!cboComboBox1.column(1) but trigger if from an other (sub) form.

    Hope someone has a solution.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

  3. #3
    Join Date
    May 2012
    Posts
    89

    Thx its done!

Posting Permissions

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