Search textbox

[SueM]

Hi,

I'm trying to create a form from which customers can use a
textbox to search a database for an item they have named n
the textbox.

I want these values will be returned in a list box, or in
such a way that they are listed to enable the user to
select the one that is correct for their needs.

I've tried DoCmd.FindRecord "Apples",,True,,True but I'm
not sure how to get the value of the textbox into this
macro.

Is there a better way of attempting this??

Cheers,

Sue

 

[Jim/Chris]

The method I use is to creat a combo box on the form using
the combo box wizard. The wizard will walk you through
each step. When completed the record selected will be
retrieved.

Jim