Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78

    Unanswered: Passing values between forms

    Hi,
    I want to pass some values from one form to another. What is the best way of doing this?
    the light is on, someone is home, but they dont know they are. HELLO!

  2. #2
    Join Date
    Jun 2003
    Location
    UK
    Posts
    68
    Quite easy. Create a module normally called basDeclarations. In this module you can declare Global vriables that can be used to store information that can be used anywhere in your database.

    Paul

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Version of access? Check your OpenForm method of DoCmd ... THere should be an OpenArgs parameter ... You can pass multiple parameters by building a string and using a token separator and pass that as the argument.

  4. #4
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Cool Get and LET

    Syntax LET

    [Public | Private] [Static] Property Let name ([arglist,] value)
    [statements]
    [Exit Property]
    [statements]
    End Property



    Syntax GET

    [Public | Private] [Static] Property Get name [(arglist)] [As type]
    [statements]
    [name = expression]
    [Exit Property]
    [statements]
    [name = expression]
    End Property

    see 4 further info Helpfiles

  5. #5
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by M Owen
    Version of access? Check your OpenForm method of DoCmd ... THere should be an OpenArgs parameter ... You can pass multiple parameters by building a string and using a token separator and pass that as the argument.
    Stupid question coming up. If I use the openargs parameter how do i then retriece the info on the other form?
    the light is on, someone is home, but they dont know they are. HELLO!

  6. #6
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile

    Originally posted by dapman2002
    Stupid question coming up. If I use the openargs parameter how do i then retriece the info on the other form?

    Me.OpenArgs

    Gregg

  7. #7
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78
    Originally posted by basicmek
    Me.OpenArgs

    Gregg
    doh
    the light is on, someone is home, but they dont know they are. HELLO!

Posting Permissions

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