+ Reply to Thread
Results 1 to 2 of 2

Trying to display row data on a new subform from a combo box on the form before it in VBA

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Blacksburg, Virginia
    MS-Off Ver
    2013
    Posts
    18

    Trying to display row data on a new subform from a combo box on the form before it in VBA

    I have a form with a combo box of people's names and am trying to display the data (that's in the same row as the name) on a new form. I am having trouble getting the value of the combo box onto the new form to display the name, any thoughts?

    This is the form for the combo box
    Please Login or Register  to view this content.
    This is the form where I am trying to display the information relative to the name selected from the combo box

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Trying to display row data on a new subform from a combo box on the form before it in

    Instead of unloading the first userform hide it then you can read the value from the combobox in the second userform's Initialize event.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 10-23-2014, 10:43 AM
  2. Form with Subform and combo boxes to filter
    By CRIMEDOG in forum Access Tables & Databases
    Replies: 0
    Last Post: 07-18-2013, 05:46 PM
  3. Main Form Multiple Combo Boxes Control Subform textboxes
    By jvbeats in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-01-2013, 01:36 PM
  4. combo box to display multiple records in a form
    By stats09 in forum Access Tables & Databases
    Replies: 12
    Last Post: 12-15-2010, 12:41 PM
  5. [SOLVED] cascade combo in subform
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2005, 05:55 PM

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