Report field change on the fly

[Guest]

"Delivery address", "Pay to" sometimes needs to be a different address or
different payee than the Vendor Name.
Like "will pick up" etc. The Reports have lbl field for the delivery address
that have this information at this point or are bound to the qry with the
Vendor name as the payee.

I made a form that is unbound but I don't know how to write the vba to
referance the purchase order report when I have the pop up form with the new
information visible so it will write it to the report before printing. (I am
not sure this is even possible)

report name: rptPO
field:SupplierNamePay
control:SupplierName

form:f_DeliveryAddress
fieldayTo
control:unbound

So if I put a new payee in the unbound field is there a way to write it to
the report. It doesn't have to store it.

thanks!

 

[Brendan Reynolds]

Have you seen my second response to your earlier thread ('REPORT LBL
change')?

It is not the form that writes to the report, but the report that reads from
the form. My second response in that earlier thread includes an example.

 

[Guest]

Answered inline

Have you seen my second response to your earlier thread ('REPORT LBL
change')?

I did and I followed it through as far as I could but as I posted I still
don't know how to get the information changed in the report

It is not the form that writes to the report, but the report that reads from
the form. My second response in that earlier thread includes an example.

Ok if I put a new payee in the unbound field of the pop up formis there a
way to "read" it from the form and show it in the report. It doesn't have to
store it.

Thanks...