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
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
In the search box, run an append query to a LogHist table,
the list can show the table.
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
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.
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?
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.
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