Search fields

[Fredofthreads]

How would i create a drop down search box that pulls down all the options for two fields as you rite them?

Ex. On the top of a form a box that says search supplier and as you type "fi" and it is showing underneath firefox, film store and fire station.

 

[NXMold]

Hmm, I have seen a FAQ about that someplace but I don't think it was this site.

You might try playing with the keypress events... each keypress does a save/requery, then an afterupdate to display new results (which you might already have).

 

[PHV]

You may consider a ComboBox with AutoExpand set to True.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886