Data not saving to ID

[louisa]

Hi everyone,

I have a table called billing, which contains InvoiceID, ContactID, InvoiceNo,Amount and Paid fields.

When i add data to my form the data does not save in the form so on closing and reopening anything entered has dissapeared. If i enter the table the data is there with an invoice ID (auto number) but has not matched to the ContactID. I feel what i want is simple enough but is not working, i have 53 records stored in my table and when an invoice is generated i will go on to my form 'Contacts' select the record i am needing to add data to. Hit my 'Billing' tab and enter the info of the invoice and have it save and assigned to that record. But it is not assigning itself to the contact ID nor saving in the form itself..... Any help will be greatly appreciated.

 

[HiTechCoach]

Are any records getting added to the table when you open the table directly?

 

[louisa]

The data saves in the table and is giving an Invoice ID (autonumber) but it also has contactID (number) so i need the data to be assigned with the contactID that has already been assigned. I.E I have a contactID of 36 for one customer so when i enter the invoicing info and i go into the table it has been given an autonumber (invoiceID) but the contactID is blank so it hasnt assigned that information to that customer???

 

[HiTechCoach]

are you using a sub form to enter the invoice data?

 

[louisa]

yes it is a subform, a tabbed form within a tab

 

[HiTechCoach]

With sub forms, normally you use the Master/Child linking fields properties to tell Access how to automatically link the data. Have you check to see if these properties have been set correctly? If not, that would cause your issue.

 

[louisa]

from form billing they have been set to link contact id but the data is still not linking to the contact id.