Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    7

    Unanswered: How to Open single form multiple times (all together) in MS Access

    Hi,
    I want to open a form in MS Access multiple times (all together) after clicking on a button. Example I have a multiple selection CLIENT list box in first form. Suppose I selected 3 Item form the list and clicked on the button, Then the second form must be open 3 times with the indvidual information of all 3 client information. Mean to say same form must be open 3 times with different informations, Same form will open 3 times all together, Same 3 form will be visible on the screen but all will have different informations.

    Thanks,
    Raj

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

    Lightbulb Object oriented programming

    1. Make a Module lets call it MdlOpenForm
    Where you declare something like this

    Public NewForm As New frmYourFormName

    2. Under this make a : Public Sub Button_Press(pForm AS Form,SelctedItem_ID as Int)


    in this section you set the code that now is under the button, replace the Me (Me.Listbox) into pForm.Listbox

    'After thiscode
    instead of opening the "real form" , DoCmd open frmYourFormName
    You type : DoCmd open.pFrom

    3. Now in the buton click you set the following routine :

    for each MyListbox.SelctedItem

    MdlOpenForm.Button_Press(Me,SelctedItem_ID)

    next

    Cascade

  3. #3
    Join Date
    Oct 2003
    Posts
    7

    Talking Thanks Marvels

    Thanks Marvels for the code.
    Raj

Posting Permissions

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