Results 1 to 3 of 3
  1. #1
    putadokta is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2

    search criteria help


    Hi to one and all This is my first post here.. I hope that you can help me I am developing a database The database needs to list the records in a listbox and then when a record is clicked the details come up, The problem i have is I need a method for getting/filtering all the records that begin with First character into the listbox. I have 27 command buttons listed down the page from A-Z, What I am trying to achieve is instead of using a dropdown box all The time. Is when you click a button i.e 'P' just the Artists name appears in a list box or the dropdown box. Because when I have finished updating the records The dropdown box way is going to be to long to scroll. I am enclosing Database to see if you understand me. Any pointers or help would be much appreciated ACCESS 2010

    Attachment 6039

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Get your data structure sorted out first. You talk about listing artists but when I look at the list box it is attached to a table called vehicles! The design of the tables should always be the first thing you do, then you can start building forms, queries, etc. on top of that. Put real data in so that you can easily see when something is working or not.

  3. #3
    putadokta is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2
    Problem solved

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

Similar Threads

  1. Search Criteria Error
    By hitesh_asrani_j in forum Forms
    Replies: 25
    Last Post: 09-29-2011, 10:35 AM
  2. Complex Search Criteria
    By dutrac6835 in forum Queries
    Replies: 8
    Last Post: 06-23-2011, 04:11 PM
  3. Search Criteria
    By Meccer in forum Forms
    Replies: 1
    Last Post: 04-01-2011, 12:53 PM
  4. Search By Criteria - Flexible Criteria Fields
    By lilanngel in forum Access
    Replies: 0
    Last Post: 03-16-2011, 06:25 PM
  5. Search with multiple criteria
    By injanib in forum Forms
    Replies: 1
    Last Post: 01-16-2011, 11:51 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