In the main form (as there are many) if I go into the property sheet of the form and then go into record source it states,
SELECT [tblCustomerInfo].[Surname], [tblSalesSheet].[Job No], [tblSalesSheet].[BkgDate], [tblSalesSheet].[BkgTime], [tblSalesSheet].[AM/PM], [tblSalesSheet].[Staff Init], [tblSalesSheet].[Job], [tblSalesSheet].[Office Use Only], [tblSalesSheet].[Driver], tblSalesSheet.[InvoiceYN], tblSalesSheet.[InvNum], [tblSalesSheet].[Vat Rate], [tblSalesSheet].[Vat (inc)], [tblSalesSheet].[S Total], [tblSalesSheet].[Deposit], [tblSalesSheet].[Misc+], [tblSalesSheet].[Invoice Total], [tblSalesSheet].[Parts], [tblSalesSheet].[Labour], [tblSalesSheet].[Paid/Not], [tblSalesSheet].[P Method], [tblSalesSheet].[Print Inv?], [tblSalesSheet].[Paid Date], [tblCustomerInfo].[DoorNo], [tblCustomerInfo].[Postcode], [tblCustomerInfo].[Title], [tblCustomerInfo].[Address], [tblCustomerInfo].[Address 2], [tblCustomerInfo].[Town], [tblCustomerInfo].[City], [tblCustomerInfo].[HomeNumber], [tblCustomerInfo].[WorkNumber], [tblCustomerInfo].[OtherNumber], [tblCustomerInfo].[Customer Info], tblSalesSheet.[Book Del?] FROM tblCustomerInfo INNER JOIN tblSalesSheet ON [tblCustomerInfo].[Customer Number] =[tblSalesSheet].[Job No];
Yes, I click the save button. Also I get to the end of the form fields and it rolls onto the next record to enter. In some cases I enter a second and third record.
I go out of the form and then go back and those records are not there but if I go into the tables then the data is there.
No, its not filtered.
Thanks for the help. Its absolutely drove me insane trying to work it out today and ive got nowhere.