+ Reply to Thread
Results 1 to 6 of 6

how to interact between forms?

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    Question how to interact between forms?

    Hello again,
    I have a search form. If the item sought already exists, it opens a second form asking, for example, if you want to edit the existing one. If the user selects YES, then when he clicks OK, the sheet should open. If he selects NO, then nothing happens.

    In my code, works like this:
    If he clicks YES, then a Boolean variable receives TRUE and it returns to previous form. If he clicks NO, the variable receives FALSE and it returns to previous form. However, It's not working, although it is a global variable. How could I "transfer" this variable, ie how to use it as a parameter in another form?

    taking the question. This same form isn't going out with "Unload AskForm", just with "AskForm.hide". Is there a dangerous difference?
    Last edited by marlonsaveri; 03-09-2011 at 02:10 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: how to interact between forms?

    Why have two forms? Use one form with a MultiPage control
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: how to interact between forms?

    The second is as a alert. When we write something that already exists, the second is displayed: "hey, this value is already registered! Would you like to edit? Yes / No"

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: how to interact between forms?

    Why not use MsgBox instead of a new form?
    Remember what the dormouse said
    Feed your head

  5. #5
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: how to interact between forms?

    'cause I had tried and I make some mistake. So I gived up and try to make a new form. Do u know how? Thanks so much.
    I'll look for it on web.

  6. #6
    Registered User
    Join Date
    01-27-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2007
    Posts
    75

    Re: how to interact between forms?

    Better, thanks.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1