I HAve A form with a combo box on it and when I Press the Button I Want to Change the row source of the conmbo box to:-
SELECT Street.SID, Street.Street, Postcode.Postcode
FROM Postcode INNER JOIN Street ON Postcode.PID = Street.Postcode
WHERE (((Postcode.Postcode) Like "*N1*"));
but the bit...