Results 1 to 2 of 2

Thread: assigning the form name

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 1999
    Location
    St. Louis, MO USA
    Posts
    21

    Question

    How can I pass a form name to a variable in order for another form to access it.

    Example:

    If datetype = "from" Then
    frmCellByBudget.fromDate.Value = axcalendar.Value
    Else
    frmCellByBudget.toDate.Value = axcalendar.Value
    End If


    FrmCellByBudget is just one of the five forms that could be called in this subroutine. Is there a way to assign the form name to a variable and replace frmcellbybudget with the variable?

    [Edited by hbarker on 07-26-2000 at 04:08 PM]

  2. #2
    Guest
    Declare it as a Form

    Code:
    Dim MyVar As Form
    Set MyVar = Form1
    
    MyVar.Visible = False

Posting Permissions

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



Click Here to Expand Forum to Full Width