Cant Add Record From Query To Form? Recordset Error

[hullstorage]

Hi all,

I have attached a copy of my database.

I am trying to create a form to add records to a given invoice number, tried numerous things but getting different errors.

There are many jobs for each invoice number.

Eventually, I need to create some sort of dmax funtion where when i enter the account number whis will bring up the last invoice number for that given account where the invoice has not been posted.

So, my first hurdle is sorting this error out first.

If you take a look at the customer table and look at the relationship this should give you an idea.

Many thanks,

Thanks all

Simon

 

[Guus2005]

You might want to reconsider your database design.
Customers and InvoiceDetails have repeating groups and the customer table also has warehouse data in it. This should be an Id to the Warehouse table.

You use a subform (query1 subform) in the Form1 but you didn't connect them using the "Link Master Fields" and "Link Child Fields".

HTH