I'm trying to play a mp3- file in MS Access VBA. I already finda script that opens mine music player NERO. But how could I play a mp3 file?

Hello,

I don't think that you need an union query. Both queries got the fieldname Owner. So make a new query with the two tables with an join on Owner. Select all the fields you needed and you you will get one row.

Query:
SELECT Boats.Owner, Boats.Boat, Boats.Type, Boats.Color, Boats.Year, Boats.Seating, Boats.MaxWeight , CARS.Car, CARS.Mileage, CARS.Make, CARS.Year, CARS.color, CARS.MPG
FROM Boats INNER...