Results 1 to 4 of 4
  1. #1
    dweekley is offline Advanced Beginner
    Windows XP Access 2002 (version 10.0)
    Join Date
    May 2010
    Posts
    52

    Populate lsitbox based on multiple textboxes

    I am looking to create a search form. I have created the form with 2 textboxes, and using a button to apply the textbox values to limit the listbox contents.



    The listbox control source is currently a query. In both the Cust ID and P/N criteria in the query is Like "*" & [forms]![formname]![controlname] "*" so every thing will populate. having trouble remembering how to apply the textbox values to the query.
    Attached Thumbnails Attached Thumbnails search form.jpg  

  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,643
    Me.ListboxName.Requery
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    dweekley is offline Advanced Beginner
    Windows XP Access 2002 (version 10.0)
    Join Date
    May 2010
    Posts
    52
    Ugh...Thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    No problem.
    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. Replies: 1
    Last Post: 03-21-2018, 03:32 PM
  2. Replies: 2
    Last Post: 08-21-2013, 09:39 AM
  3. Populate textboxes on a report from a query
    By dccjr in forum Programming
    Replies: 3
    Last Post: 05-14-2013, 07:31 AM
  4. Replies: 3
    Last Post: 04-03-2013, 11:29 PM
  5. populate textboxes via comboboxes selection
    By white_flag in forum Access
    Replies: 3
    Last Post: 09-08-2011, 01:03 AM

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