SIMPLE RECORD FIND!!!!

[Vuen]

Does anyone use Quickbooks? You know when you click 'invoices' and start typing a name in the box, it fills in the rest of the box with the nearest of that name in selected text, so if you keep typing it keeps replacing the rest of the box you haven't typed yet? I NEED TO KNOW HOW TO DO THAT!!! I can make it fill the rest of the textbox in selected text, I just can't make it find the nearest record! HOW! ANSWER MY POST EVEN IF YOU DONT KNOW HOW I AM MAD THIS ISNT FUNNY!!!!!!!!!!!

[JonnyCab]

I use a datacombo box, fill it using ADO (DataEnvironment Addon)ie Select 'Data Environment' under Project/Components/Designer. By playing with the combo box properties...

Style = 2. Dropdown list
MatchEntry = 1. Entended Matching

...it does what you want to do. However, have never tried doing this with normal combo box and DAO. (Not sure if you can)

Good Luck

[RIVES]

Ever tried the help index of a windows application? When you type, it goes to the nearest match...

In an ordinary combo box, you could do that with API calls. I think that this site has a tip for doing just that. Try looking for it first and explore the power of Visual Basic.

Good Luck.

[stickleprojects]

hi,

MSForms.ComboBox control does what you want (not the normal VB one!)
Set the MatchEntry property to the setting you wish (probably MatchEntryComplete).

Hope this helps.

[Vuen]

Phew
Thanks all I'll try the datacombo box. Phew!