Recent content by jabberwokiuk

I have a report producing invoices. I would like to prevent empty date fields from producing gaps in the customer address - a bit like the ignore blanks command in Words mailmerge. My first thought was to create some code that copies the address fields into an array then sorts through the array...

Thanks Neilg That worked, I just rebuilt the form from scratch. When I look at the child/master links they look the same between the old and new versions!?! But hey it works :)

Hi guys, I am fairly new to access - I think I undertand normalisation and relationships between tables. I am trying to set up a simple pro-forma invoice database. I have three related tables: tblInvoice -> tblCourse -> tblDelegates (all one to many with RI enforced CD) I have created a...