Synchronised form-report

[MAZLAN]

I want to add a print button into a form. How to make sure that the record which is diplayed in the form is the same record that is going to be printed from the report file.
Thanks in advance.

 

[KevinM]

On the OnClick of the button put...
Docmd.OpenReport "MyReportName",acNormal,,"[MyId]=[Forms]![MyID]"

Change the above to your names

HTH

Kevin M

 

[KevinM]

Oops..slight mistake, that should be...
[Forms]![MyFormName]![MyID]

Sorry

Kevin M

 

[morpheus]

What about if you don't want a dialog pop-up asking for the ID number to sync the report to? Most users are going to be at a loss when a window pop-ups saying

Forms!YourFormName!YourFieldName with a text entry field? You have to design with the end user in mind, so how do you make it "grab" the information already displayed on the current form recordset being displayed?

I have been struggling with this for a couple days. I don't want any secondary pop-ups where i have to fill in anything, i want the report to simply pull what i have displayed and nothing else.

Any other takers on this one?

 

[Richie]

it sounds as if you have entered the code or syntax incorrectly.

 

[KevinM]

You obviously haven't read my second post correctly. The answer to your problem is there.