+ Reply to Thread
Results 1 to 4 of 4

Problem with dates in Rowsource

  1. #1
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Problem with dates in Rowsource

    I have attached the file that i'm having issues with. On the userform, frmEditData, I have included a combobox (combobox5) that filters the different rows that show up in listbox1. once you click on an item in listbox1, it populates the rest of the form. This works for all the different filters, except when it is a date. An example would be clicking on Date of Loss in combobox5.
    What would I need to do to fix this? Please Help!! Thanks
    Last edited by brouhaha501; 02-24-2010 at 09:43 AM.

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

    Re: Problem with dates in Rowsource

    Try this one.
    Attached Files Attached Files
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Problem with dates in Rowsource

    It works amazing! thanks so much!!

  4. #4
    Registered User
    Join Date
    01-27-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Problem with dates in Rowsource

    I ran into one other problem. When two rows have the same date in one of the fields, it will only show the top row in the information tabs. I have attached an updated version with all of the dates in field F the same. when you click on each date in listbox1, it will only show the top row in the fields to the left. What would i need to do to correct this as some of the dates may be the same?
    Attached Files Attached Files
    Last edited by brouhaha501; 02-22-2010 at 09:58 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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