Hi Peter. Welcome to the forum :)
Before you start on the Front end it would be wise to ensure that your tables are designed and related correctly.
Can you post a copy of the db or show us a picture of your relationships window.
Thank you, gentlemen. Clearly, I've had another "senior" moment. I thought they were downloads for 32/64 bit versions of OFFICE.
Sorry to be a bother and thank you for your help and patience.
Have you tried creating a new db and importing the relevant form, query and table. Delete all records in the new db and then create a couple of fictitious records. Compact, zip and post the file.