Results 1 to 2 of 2
  1. #1
    mikejames is offline Novice
    Windows Vista Access 2003
    Join Date
    Sep 2011
    Location
    Southern Michigan
    Posts
    16

    Red face Listbox


    Hi I would like to place a date field (calendar) in the header and a list box in the form that lists data based on the date selected above. I can accomplish this with a sub form, but once the info is in the listbox i would like to click on it and open a form to edit the data. Thank you for your help.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Basically it's the same as a cascading combo:

    Baldy-Cascading Combos

    You'd update the listbox in the after update event of the date textbox. For opening the form:

    BaldyWeb wherecondition
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. listbox help
    By imintrouble in forum Access
    Replies: 2
    Last Post: 10-20-2011, 01:53 PM
  2. Right Align Listbox
    By brc in forum Access
    Replies: 16
    Last Post: 07-12-2011, 07:06 PM
  3. Listbox Help
    By allykid in forum Programming
    Replies: 2
    Last Post: 03-30-2011, 06:17 AM
  4. How do I get data from a listbox?
    By cowboy in forum Programming
    Replies: 1
    Last Post: 06-15-2010, 02:28 PM
  5. Horizontal listbox - ?
    By bane in forum Forms
    Replies: 3
    Last Post: 04-20-2010, 06:48 PM

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