Close

Results 1 to 4 of 4
  1. #1
    DF VIP Member MonkeyBalls's Avatar
    Join Date
    Mar 2005
    Location
    Flowery Tw*ts
    Posts
    1,714
    Thanks
    0
    Thanked:        0
    Karma Level
    370

    Default Passing Valuables Between Forms In Access

    Hey Guys

    I've got a form (Form1) in access with 3 fields:

    user text entry of a number called intFormula
    user selected drop down box called CurrentDrop
    user selected drop down box called Proposed Drop.

    The idea is Form1 opens F:Exchanges showing only data corresponding to CurrentDrop and Proposed Drop, then does calculations based on data in a table using the inFormula expression.
    An automatic command button has been created which opens all the records compared to CurrentDrop, and the ProposedDrop and intformula are to be passed across to used in other code which i know works i just can't pass the fields over.

    Can someone give me some pointers, its been a while since i've done any of it!?

    Please and thank you!
    K+ For the correct working answer! hehe!

  2. #2
    DF VIP Member flipper321's Avatar
    Join Date
    Feb 2003
    Location
    Essex
    Posts
    2,696
    Thanks
    11
    Thanked:        131
    Karma Level
    474

    Default Re: Passing Valuables Between Forms In Access

    How are the 3 variables defined.

    Sounds like they need to be publicly defined outside of the form...

    If the variables you are talking about are defined in the form design sheet then I'd suggest you create 3 new public variables and pass the numbers to those...

  3. #3
    DF VIP Member /dev/null's Avatar
    Join Date
    Feb 2004
    Location
    Behind You
    Posts
    2,952
    Thanks
    0
    Thanked:        0
    Karma Level
    450

    Default Re: Passing Valuables Between Forms In Access

    ^^as said above, declare your variables public such as:

    public intformula as integer

    then assign your values to those before referencing them from your other forms.

  4. #4
    DF VIP Member MonkeyBalls's Avatar
    Join Date
    Mar 2005
    Location
    Flowery Tw*ts
    Posts
    1,714
    Thanks
    0
    Thanked:        0
    Karma Level
    370

    Default Re: Passing Valuables Between Forms In Access

    Cheers uys i actually gott it working using a control method...bit over compmlicated but i'll post it when i get back into work tomorrow if anyones interested?

Similar Threads

  1. Need a good cheap Host that works easily with forms!
    By Piratevirus in forum Web Hosting & Domain Names
    Replies: 11
    Last Post: 12th November 2002, 11:55 AM
  2. need access but don`t know password
    By yorg in forum PC Problems
    Replies: 4
    Last Post: 11th October 2002, 06:59 PM
  3. access problem
    By Aware in forum Forum Bug & Error Reports
    Replies: 1
    Last Post: 30th September 2002, 09:24 PM
  4. Free to access channels
    By benjiguy in forum Digital Satellite TV
    Replies: 4
    Last Post: 23rd September 2002, 09:56 PM

Social Networking Bookmarks

Posting Permissions

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