Filter by selection?

[royt]

In my earlier version of Access I had a simple macro using 'filter by selection' to list all records with the same surname, using a combo box.



Enter name say 'smith' press enter ,macro runs, hey presto all kisted.

In Access 2000 the 'run command' 'filter by selection' is not available.
How can I do this search now, without all the fuss of a query.
I just want to enter the name and find all records with the same name.

Surely a commercial database can do this without expecting the customer
to learn VBA programming!

Help please for a numpty!

NOW FIXED,THANKS TO ALL HELPERS!

[June7]

I just tested creating with Access 2010 a filter combobox. The wizard builds an embedded macro. I know embedded macros aren't a feature of Access 2002 but can't believe the wizard won't still create the macro you need. Review this http://support.microsoft.com/default...b;EN-US;287658