find record using textbox and command button

[Guest]

how do i create a search button using just a command button and a textbox

 

[Allen Browne]

Use the AfterUpdate event of the text box (or the Click event of the button
if you wish) to FindFirst in the RecordsetClone of the form. Test NoMatch,
and set the Bookmark of the form.

There's an example in this article:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

The article explains how to set up a combo box, but the code is exactly the
same for a text box.

 

[chriske911]

Rolling has brought this to us :

how do i create a search button using just a command button and a textbox

why not use a combobox?
this is the default way for what you are trying to do

if you add a combobox to your form the wizard will automagically create
the required code
just select the correct parameters
inspect that code and you will see the light ;-p

grtz