Hey there.

I've got a form for vehicles, and from here I want to be able to click a button which will filter the records, (for that particular vehicle) showing records containing the words 'tyre' or 'tyres'.

Is this possible, and if so, how?

Regards
zico

take look at this sample database.

http://www.mvps.org/access/downloads/findrecord2k.zip

do you how to create a command button using the wizard ? if yes, you can use the wizard to create a button and wizard will also ask you if you want to open a form based on some match field.

try it and you will know what i am talking about.