Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61

    Red face Unanswered: Subform Datasheet

    I got a subform datasheet on my my form.
    The user fills the length's from the valves to the branch in.

    But how can i get the values that they filled in. So i can use them for calculations?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Subform Datasheet

    Originally posted by DeathWing
    I got a subform datasheet on my my form.
    The user fills the length's from the valves to the branch in.

    But how can i get the values that they filled in. So i can use them for calculations?
    Once the user "saves" the record retrieve the numbers thru either a query or thru the textbox control (if you only need the current row) ...

  3. #3
    Join Date
    Nov 2002
    Location
    The Netherlands
    Posts
    61
    Is there anyway to get them all?

    For instance wenn i load a saved one i get maybe more lengths then 1.
    The calculation needs all the distances to calculate the amount of decibel.

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by DeathWing
    Is there anyway to get them all?

    For instance wenn i load a saved one i get maybe more lengths then 1.
    The calculation needs all the distances to calculate the amount of decibel.
    Query for them ... You do know the name of the table right?

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I read the post am not sure I know exactly what you are asking but... If you are trying to get all of the data the user typed into a continuos subform then you can create a recordset object and set it to the subform recordset like:

    dim rstSubformData as Recordset

    set rstSubformData = Me.subSubformName.Form.RecordsetClone

    Then you can loop through the recordset to do your calculation.

Posting Permissions

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