Export form data to report

[rev_ollie]

Hey,



Can anyone help me with a solution to send form data to a report.
I want to be able to make a button on my form that will make all of the filed on the form inactive i.e cannot be changed, and then the data is sent to a report as an invoice.

I'm fairly sure its stright forward but can't seem to find an answer. I think its more I don't know what I'm looking for. I know what I would like just not how to get there

Any ideas?

[maximus]

To deactivate form controls use this Code:
Me.ControlName.Locked=True
or
Me.ControlName.Enabled=False

To activate just the opposite.

You are probably looking for making the report from the table and then open from the Form using a Criteria

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Report1"

stLinkCriteria = "[InvoiceNumber]=" & Me![InvoiceNumber]
DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria


I am attaching a sample mdb file. check it out.

if this solves your problem mark this thread solved.

[rev_ollie]

Ah you are a legend

Thanks very much

[maximus]

Thanks. happy to help