searching

[JohnE]

I have a form that I would like to have a textbox at the
bottom in which the user can type in the claim number and
go to that record. I realize the Edit - Find but would
prefer to just have it available to the user. The claim
number can be either all numbers or an alphanumeric. On
the table I left the claim number as text because of the
alphanumeric possibility. Next to the textbox I will have
a small GO button to go to the record. How would the
coding behind the button be done? I'm at a lost.
Thanks.
*** John

 

[Albert D. Kallal]

Try placing a combo box in the forms heading, and use the one that "finds a
record based" on what you type in.

In other words, the combo box wizard will create a box that you type in a
claim number, and the form will jump to that number.

Give it a try....