Search directly in a form

[Tom R.]

I have some members in av form, and I want to be able to in [FirstName] to
just type inn the persons name and search an get hold of all the persons data
in the form. Is there an easy way to do this?

 

[John W. Vinson]

I have some members in av form, and I want to be able to in [FirstName] to
just type inn the persons name and search an get hold of all the persons data
in the form. Is there an easy way to do this?

Yes. On the menu select Records... Filter... Filter by Form.

Type search terms in any bound control and then apply the filter.

John W. Vinson [MVP]

 

[Michel Walsh]

The control wizard for a combo box should present you with that possibility
(through a combo box, though). Have you tried it?


Vanderghast, Access MVP

 

[Tom R.]

Thank you! Just what I was looking for. =)
--
Tom R. Thorstensen

The control wizard for a combo box should present you with that possibility
(through a combo box, though). Have you tried it?


Vanderghast, Access MVP

I have some members in av form, and I want to be able to in [FirstName] to
just type inn the persons name and search an get hold of all the persons
data
in the form. Is there an easy way to do this?