Hi Larry,
Thanks for your suggestion. I don't think I was quite clear enough though.
I want the search to span multiple fields... ie, i have a product number and a
product description, I'd like to narrow the search as I type each character.
That may not be practical though, as there are many records in the database
(maybe 2000) so I was thinking, even if i could type a few characters, and
press return, and have a list of matching records returned, that would be
good. and then allow the user to type a few more characters to narow further
maybe.
Thanks anyway,
Jason
Larry Linson wrote:
That's exactly what a Combo Box does by default, so a Combo Box should do
what you want. You'd have to manually reset the AutoExpand property to False
to keep it from doing what you describe.
Larry Linson
Microsoft Access MVP
"Jason Lewis" <ja***@NOdicksonSPAM.st> wrote in message
news:3f***********************@news.swiftel.com.au ...
Hi,
I'd like to find a way of narrowing a search, as you type in a field. Kind
of
like when you have a big list, as you type, it narrows down the items in
the
list to things that match what you have typed. Can anyone point me in the
right direction or give me a link that has an example of how to do it?
Thanks,
Jason
ps. please remove NO SPAM to email me.