Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Listbox selection to pass info to new form

    Hello All!!!

    I tried searching for an answer to this question to no avail. I have a form, frmIssueEdit and on this form I have 10 combo boxs that a user can use to select and this filters the selections they can make in a list box. I have added an "On double click" event so that when the user finds the entry they want to edit they can then double click this entry and it opens a new form. What I would like the new form to do is automatically populate the information provided in their selection into the new form so that all the original information is pre-filled. I would like this information to populate in the same 10 combo boxs, but on a new form where they can edit it if they must. I appreciate any help with this and can provide more information should it be needed...thanks for your help!!!!!!!!!

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    while I don't fully follow what you seek; generically speaking - a new form opening can "call" data from an existing open form. field by field i.e.

    Me.Value1=Forms!OpenFormName.ABCTextbox
    Me.Value2=Forms!OpenFormName.123Combobox

    you can put this stack of code in the OnCurrent event or Open event.

    Hope it helps.
    www CahabaData com

Posting Permissions

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