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.

 

[louisa]

Please help me! I cannot find anything on the web,

 

[georgedwilkinson]

This has all been done before. If you can't figure it out, why not try one of the fine starter databases that already work? You can modify them to your hearts content.

The Northwind database should cover most of the functionality you need. It comes with every version of Access and SQL Server.

Also, no reason to post duplicates in 2 forums.

 

[lcook1974]

Have you tried creating an Update or Append query? the have that run based on a command button.