MSGrid Showing all records??

[MickJ]

I've set up a grid which is supposed to show maintenance work performed on vehicles. The main part of the form is linked to an Access DB which displays the vehicles, the grid is showing maintenance work for all vehicles instead of just the current vehicle. What did I do/not do??
Thanks
Mick

 

[Guest_imported]

The default is to show all, if you are using a record set.
If you oly one to see selected vehicles then you have to create a query that returns the vehicle you want ans use the query result as the record set.

 

[MickJ]

Thanks for the reply. The record is displyed, what I want the grid to do is show the relevant maintenance for the current record. In Access is was something like where RecordID=MantenanceID but I can't seem to figure it out in VB.