search to a combo box

[binghamw]

Hi I would like to have a text box where you type in a keyword. Since there may be more than one result, I would like the results displayed in a combo box. I then would like the user to select from the combo box which record to display in the fields below.

I have managed to do this fine with cascading combo boxes. However, because there could end up being many keywords, it doesn't seem very logical to do it this way.

 

[Parker]

Hi I would like to have a text box where you type in a keyword. Since there may be more than one result, I would like the results displayed in a combo box. I then would like the user to select from the combo box which record to display in the fields below.

I have managed to do this fine with cascading combo boxes. However, because there could end up being many keywords, it doesn't seem very logical to do it this way.

Take a look in the samples forum. there are a few samples in there including one from me

 

[jfgambit]

http://www.access-programmers.co.uk/forums/showthread.php?t=62853