Add items to subform

[foxtet]

Hi Guys,
In the database I have Billing details form. I want add items to frmInvDetails. so that the invoice # should be from frmInvoice.

Sample db is attached kindly work a solution for this

foxtet

 

[arnelgp]

try this on

 

[foxtet]

try this on

Thank you.
I didnt know how to frmInvDetails to link with frmInvoice. Could you explain little about working of this.

foxtet

 

[foxtet]

try this on

I have missed code on oncurrent event of frmInvoice. Its ok now.

However I want consigneeID and ShipperID to be displayed automatically on frmInvoice instead of selecting by the user.

It's really helpful if help on that.

Thank you!

foxtet