Results 1 to 3 of 3
  1. #1
    Access_Novice is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Posts
    265

    Two drop down lists in a table, one dependent on the other

    At this point I don't want to work with forms. I would like the user to enter information directly into an Access table (it's ok). I want one column to have month ended. In this column, there would be a drop down/lookup menu with each month of the year. The user selects the month we are being billed for.



    Then another column called week ending date, would display all week ending dates (ends on a Sunday) but only for the month that was selected.

    If the user selected another month on another row, the available weekending dates to select from would show only what pertains to the month selected.

    Is it possible to do this?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Research Cascading Comboboxes. I take it you'll have a series of months with week ending dates in a table.I really wouldn't want users interacting directly with a table.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    This requires a little code in the first combobox AfterUpdate event to requery the second combobox. And no, can't do with a table or query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 01-27-2014, 12:19 PM
  2. Replies: 1
    Last Post: 11-30-2013, 03:43 AM
  3. Replies: 3
    Last Post: 10-25-2012, 09:37 PM
  4. Replies: 1
    Last Post: 08-02-2011, 06:23 AM
  5. Complex Table "Lookup" Lists
    By Rawb in forum Access
    Replies: 19
    Last Post: 03-01-2011, 02:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums