yup thanks for the replies Venue and Event are the names of the tables and I have tried to run the program without the line WHERE (([where Venue].[venueID]=[Event].[VenueID]));
but its linked but not properley but someone has suggested making an SQL query within the form rather than in the recordsource property of the ADO control, which i will try