get data from main form to subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Hey Thanks very much I see where you are coming from.
After using ur suggestions. I was able to solve the situation

Pat Hartman(MVP) said:
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.

Levans digital said:
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
Click to expand...
Click to expand...
 
Back
Top