Invoice and subforms

[potatoheadsir]

Hi everyone,



I have a customer and invoice database I am working on. I have tables:
CUSTOMER(CustomerID{PK}, FirstName, LastName, Address, etc)
INVENTORY(InventoryID{PK}, ItemCode, Itemdetails,ItemUnitCost, ItemSalePrice)
INVOICE(INVOICEID{PK}, CustomerID, OrderDate, Comments)
INVOICEROWS(InvoiceRowsID{PK}, InvoiceID, InventoryID, Quantity, UnitPrice, InvoiceRowtax, Total Price)

I am currently working on the invoice section. I have a form that shows InvoiceID, CustomerID, Comments and within that, a subform with the INVOICEROWS as continuous forms. Link Master and Child with INVOICEID. The INVOICEROW shows option to choose InventoryID, input quantity, UnitPrice, TotalPrice, and then a =Sum[totalprice] at the bottom.

I am having trouble with the INVOICEID on the mainform to generate the next autonumber, it always says (New). THOUGH when I enter something in the comment section it will show a number.

What am i doing wrong?

[June7]

Check the main form DataEntry property - is it set to Yes? If so, then form is set to open only to NEW record. This is not what you want?