Filter

[Guest]

I want an unboud field in the form header, and when I type something in for
example 123456 it searches all feilds? I am not sure how to write the code
for that.
My Unbound Field is called SearchAll
Thanks
Chey

 

[Joseph Meehan]

I want an unboud field in the form header, and when I type something
in for example 123456 it searches all feilds? I am not sure how to
write the code for that.
My Unbound Field is called SearchAll
Thanks
Chey

Unless it is an mde file you should be able to look at the code for the
one you have.

 

[User]

There is a wizard that allows you to put a combo box on a form header and
when you choose a value (or enter a value) it navigates to the first
matching record. That is a starting point for what you want, but you can go
into the code and extend it to search all the fields you want (by extending
the criteria in the "findfirst" statement). Then you can convert the combo
box to a textbox.

Doug