find record using textbox and command button

A

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.
 
C

chriske911

Rolling has brought this to us :
how do i create a search button using just a command button and a textbox
Click to expand...

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
 
Top