Combo box for search history?

  • Thread starter Thread starter Michael Wong
  • Start date Start date
M

Michael Wong

I want to have a combo box on my form where the user enters the string he
would like to search. The combo box would remember what the user entered but
limiting the number of entries to N, keeping only the most recently entered
string. It's a sort of search history.

I've seen this code once but couldn't find it anymore. Can someone tell me
where to find it or just give me a hint of how to do it?

Also, the entries need not be kept in the database to be used from session
to session, which I think would be a problem for a multi-user environment
(it's a back-end file), which I don't know how to separate the entries from
one user to another.

Thanks.
 
Hi Michael,
to preserve user information for each user in a multiuser
setup consider having a local table for this purpose...
assuming each user has a designated front-end.

to keep a search history you could use a listbox that has
a value list as a row source. You can use an array or
simple text functions to manipulate the listbox items (or
even a local table).

Luck
Jonathan
 
Thank you Jonathan,

I'll try to do it, but may be with a combo box which I like the autocomplete
feature. I've never tried to use the value list as a row source yet. This
one will be my first time.


Thanks
 
Michael, a value list is simply a text string with each
item separated by a semi-colon.

lst.rowsource="One;Two;Three"

luck
Jonathan
 
Back
Top