Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Unanswered: Pass information from current record to Variables

    I am trying to pass information from a form CurrForm that has a sub form. I am using the follwing code to pass the information but I can't get it to look at the information in the subform
    Dim frmCurrForm As Form

    Set frmCurrForm = Screen.ActiveForm

    With frmCurrForm
    strCName = .txtCName
    etc.....
    End With

    Is there any way to do this for the sub form aswell.

  2. #2
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    See attached.

    Cheers,
    Andrew
    Attached Files Attached Files
    There have been many posts made throughout the world.
    This was one of them.

Posting Permissions

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