find button to look in specific place

Is there a code where i can set the find button that on click it
automatically looks in the Name field and is always set to any part of field?

On Sun, 11 Sep 2005 23:41:04 -0700, "Database User"
wrote:

Is there a code where i can set the find button that on click it
automatically looks in the Name field and is always set to any part of field?

Program your own Find button instead!

Use it to set the Form's Filter property:

Me.Filter = "[Name] LIKE *" & Me!txtFindName & "*"
Me.FilterOn = True

where txtFindName is the name of an unbound textbox on your form.

John W. Vinson[MVP]

Hi John -
I hate to be dense, but I don't know how/where to enter the code you
suggested.

What I had hoped to do was to insert the good ol' binoculars on my form so
that, say, if I had my cursor in a certain field, I could enter the name...
or number... or whatever.... I was looking for & jump there. A find/replace
button right on the field.
Can you suggest how to do that?

--
Thanks for your time!


"John Vinson" wrote:

On Sun, 11 Sep 2005 23:41:04 -0700, "Database User"
wrote:

Is there a code where i can set the find button that on click it
automatically looks in the Name field and is always set to any part of field?

Program your own Find button instead!

Use it to set the Form's Filter property:

Me.Filter = "[Name] LIKE *" & Me!txtFindName & "*"
Me.FilterOn = True

where txtFindName is the name of an unbound textbox on your form.

John W. Vinson[MVP]

On Sat, 8 Oct 2005 05:21:01 -0700, NC_Sue
wrote:

Hi John -
I hate to be dense, but I don't know how/where to enter the code you
suggested.

In VBA code in the Click event of your new search button.

What I had hoped to do was to insert the good ol' binoculars on my form so
that, say, if I had my cursor in a certain field, I could enter the name...
or number... or whatever.... I was looking for & jump there. A find/replace
button right on the field.
Can you suggest how to do that?

You may want to use the very capable "Query By Form" technique. Click
the Filter by Form icon on the toolbar.

John W. Vinson[MVP]

Thanks for that answer - but i think i would prefer to look in the whole form
- the main form (because there are subforms attached) and any part of field
so what do i do - replace the name of the form with name or is thre more
changes i have to make?

Me.Filter = "[Name] LIKE *" & Me!txtFindName & "*"
Me.FilterOn = True


"John Vinson" wrote:

On Sun, 11 Sep 2005 23:41:04 -0700, "Database User"
wrote:

Is there a code where i can set the find button that on click it
automatically looks in the Name field and is always set to any part of field?

Program your own Find button instead!

Use it to set the Form's Filter property:

Me.Filter = "[Name] LIKE *" & Me!txtFindName & "*"
Me.FilterOn = True

where txtFindName is the name of an unbound textbox on your form.

John W. Vinson[MVP]

Also i forgot to ask, will this code give me the little find menu like the
find button gives where i can do find next etc. Or is it setting a filter
that i have to remove afterwards- i dont want that!
Thanks

"John Vinson" wrote:

On Sat, 8 Oct 2005 05:21:01 -0700, NC_Sue
wrote:

Hi John -
I hate to be dense, but I don't know how/where to enter the code you
suggested.

In VBA code in the Click event of your new search button.

What I had hoped to do was to insert the good ol' binoculars on my form so
that, say, if I had my cursor in a certain field, I could enter the name...
or number... or whatever.... I was looking for & jump there. A find/replace
button right on the field.
Can you suggest how to do that?

You may want to use the very capable "Query By Form" technique. Click
the Filter by Form icon on the toolbar.

John W. Vinson[MVP]