Results 1 to 8 of 8
  1. #1
    anthony@aahs.us is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    14

    create a drop-down list from Searched Records with a text box

    I search records in by record ID.

    I would be very helpful to be able to look back of recent searches instead of re-keying each time



    How can I store this list so I can use a list box instead of a textbox

    Thank You for any help you may supply

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In the search box, run an append query to a LogHist table,
    the list can show the table.

  4. #4
    anthony@aahs.us is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    14
    Thank You for the suggestion, however I have no problem creating searches what I am wanting to do is to store that data of what I have searched for daily so I can use the drop down list to recall it without re keying the data

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    So you want to store the search criteria? If yes, then a table eg tblSearchCrit, could be used along the lines that ranman suggested.
    Then use the table as the rowsource of your combobox.

  6. #6
    anthony@aahs.us is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    14
    not quite sure your suggestion, but I think you are saying to create a history table as i do the search and then query that list for the drop-down?
    the only thing is can I do a search from a drop-down box
    and if so would I use a not in list to then to collect the data for the loghist table?
    I feel like i'm wandering can you give me some direction?

  7. #7
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    As suggested create a search history table.

    Then add a combo box control to your form that has a row source based on the history table. (You can type in a combo box like a textbox)

    In the combo's NotInList event create a procedure that appends to the history table.

    In the combo's after update event add your search/filter code.

  8. #8
    anthony@aahs.us is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2018
    Posts
    14
    Haven't had a chance to work on issue and wont again till Monday, however I was working towards the solution you have suggested and I do believe that is the answer I will prove it on Monday and update Thank you again

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

Similar Threads

  1. Replies: 2
    Last Post: 04-22-2018, 08:45 AM
  2. Replies: 5
    Last Post: 07-05-2017, 02:36 PM
  3. Drop down list not getting records
    By Cran29 in forum Access
    Replies: 5
    Last Post: 02-05-2014, 03:34 AM
  4. Drop-Down list to display remaining text.
    By mnsemple83 in forum Forms
    Replies: 3
    Last Post: 07-18-2011, 10:29 AM
  5. I can't create a drop-down list box
    By cpuser in forum Access
    Replies: 4
    Last Post: 02-18-2008, 10:11 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