Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98

    Unanswered: Select record from pop-up form

    How can I use my form with a list of names to select one name and have it inserted in the main form?

    Any help would be much appreciated.

  2. #2
    Join Date
    Aug 2003
    Posts
    47
    Say, you have tblNames, frmMain and frmPopUp.

    tblNames has FirstName, LastName fields
    frmMain has 'txtName' text box and 'btnSelectName' button controls
    frmPopUp has 'lstNames' list box control.

    when btnSelectName button is clicked, frmPopUp is poped.

    In the frmPopUp Load_Form precedure you populate the lstNames with data from tblNames.

    lstNames has two Event Procedures 'On Dbl Click' and 'On Key Press' so when you double click or press 'Enter' key they update the txtName control on frmMain and close frmPopUp!

    See attached db for details.

    Hope this helps.
    Attached Files Attached Files
    F..ck it, gimme a beer... Jimi Hendrix RULES!

  3. #3
    Join Date
    Dec 2003
    Location
    The Netherlands
    Posts
    98
    thanks for the help!!

    I will try it. THe only problem is I have access 97 and can't open the attachement. Could you tell me what you wanted to make clear with the db attached?

    thanks again

  4. #4
    Join Date
    Aug 2003
    Posts
    47
    Oh, sorry.

    Here's 97 version of the db.
    Attached Files Attached Files
    F..ck it, gimme a beer... Jimi Hendrix RULES!

Posting Permissions

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