Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    13

    Exclamation Unanswered: Linking Form w/ Subform

    Someone please help me!

    I have a master form and a subform. The master form has a combo box that's unbounded (Unit Number) based on a query - and a series of text boxes that are filled in from an AfterUpdate [Event Procedure] that looks like the code below. This data is just for verification purposes only for the end user. This took me 2 days to figure out how to automate the text boxes from the combo. Bare with me.

    Me.Serial_Number = Me.Combo14.Column(1)
    Me.Type = Me.Combo14.Column(2)
    Me.Model = Me.Combo14.Column(3)
    Me.Department = Me.Combo14.Column(4)
    Me.Model_Year = Me.Combo14.Column(5)
    Me.Comments = Me.Combo14.Column(6)

    Now I want to add a SubForm that will bring up only the data (Date of Record, Meter Reading, Comments) that corresponds to the value in the Combo Box (Unit Number). The user should simply type in a unit number, hit enter, and it should bring him down to the next open slot in the subform. I want the end user to type in the next meter reading in the subform and simply hit enter again repeat the process. Any suggestions?

  2. #2
    Join Date
    Jul 2009
    Posts
    13
    Oh and I'm on Access 2003. I also don't seem to have a subform wizard installed on my computer. I'm at work so it's not my property.

  3. #3
    Join Date
    Jul 2009
    Posts
    13
    Oh and I'm on Access 2003. For some dang reason I don't have a subform wizard installed and can't seem to find it.

  4. #4
    Join Date
    Jul 2009
    Posts
    13
    anyone's advice would be greatly appreciated! please!

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well I didn't respond the first time because I cannot identify what problem you are having, so I have nothing to say.

    This time round, it's the same, but just so you know that most users will dodge this because (a) it is still difficult to determine what the problem is and (b) you seem to be doing some completely unorthodox things.

    All I can suggest is that there is most likely a simpler way to do whatever it is that you are trying to do.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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