Search results

I've looked, I've searched and I'm still none the wiser.

I have five tables that hold all the data required to fill in this certificate. (See attached PDF) First table is Certs. This holds CERTIFICATE NUMBER, ID numbers for CLIENT / LANDLORD'S DETAILS, JOB ADDRESS, four APPLIANCE DETAILS, four INSPECTION DETAILS including DEFECTS and REMEDIAL ACTION...

No need, all sorted now. I'd some how managed to include another table my query that wasn't needed. Got rid of the unwanted table, the query works perfectly as does the combo box, thanks for your help anyway. --------------- neilhoop

I've read your reply several times but unfortunately I don't understand it. I don't think I've explained what I want to do and what I've already done very well so here goes ..... On my form at the moment I have a text box showing the Landlord's ID (ID Client) I want to add a combo box so...

Hello. I'm a new Access 2007 user. I have two tables, Landlords and Tenants To keep things simple at this stage each Landlord has an ID number for each record and each Tenant has an ID number and a corresponding Landlord's ID number for each record. I have a form (Certs) that has a...