get data from main form to subform

[Guest]

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

 

[Pat Hartman\(MVP\)]

The records in the subform only need the primary key of the Invoice and that
should be populated automatically by the master/child links. If InvoiceNum
(# is a poor choice in a column name) is the primary key then fix the
master/child links.

 

[Guest]

Hey Thanks very much I see where you are coming from.
After using ur suggestions. I was able to solve the situation

The records in the subform only need the primary key of the Invoice and that
should be populated automatically by the master/child links. If InvoiceNum
(# is a poor choice in a column name) is the primary key then fix the
master/child links.

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