Hi pbaldy,
That's because I got so confused it isn't in there!
This is the SQL code I have written to find any records that are set as primary, but this is as far as I've got where it has worked and I don't even know if I'm on the right lines!
Code:
SELECT tblAddresses.AddressID, tblAddresses.ContactID, tblAddresses.Address1, tblAddresses.Address2, tblAddresses.Area, tblAddresses.Postcode, tblAddresses.Status FROM tblAddresses WHERE (((tblAddresses.ContactID)=forms!frmClientDonorContact!ContactID) AND ((tblAddresses.Status)= "Primary"));
No idea where to go next though.
Sorry about the delay in replies - I'm doing it at work and couldn't get to it until now.