I have a mainform [Invoicefrm) and subform [InvoiveDetailsform]
Invoicefrm has field "Invoice#" and "InvoiceDate"
I want to set the Invoice # of the mainform to each line item of the subform.
The Link master and child fields has already been used for another
operation. is there anyway this can be done. I referenced the "Invoice#"
field on the subform to that of the mainform and it works but the data is not
passed to the underlying query.
please help
|