Adding with SQL data

[vlingen]

Hi All,

I am having a "timing" issue. I have an Add button that opens a form in Add mode. The Invoice header info on top is linked by InvoiceId (autonumber)field to an Invoice detail subform on the bottom.

Tables:
InvoiceHeader: InvoiceID, CustId, InvDate...
InvoiceDetail: InvoiceID, Description, Amount...

When the form opens all the header info is defaulted from other locations, so the user just needs to click and update info in the subform.

Issue: SQL has not returned the InvoiceID to complete the link in the subform.

How do I refresh the header to generate the InvoiceId so I can enter data in the Invoice Detail subform without getting an error?

Thanks!

 

[genomon]

Issue: SQL has not returned the InvoiceID to complete the link in the subform.

What is the SQL?

Ever notice how fast Windows runs? Me neither.