Need help with report

[zozoteam]

[SOLVED] Need help with report

Dear Sir or Madame,

I am new on forum and I want to ask you for kindly help with report.
I have tables and form but I don't know how to create report to show single ID.
Every time when I made button and report, when I press the button, all records are in report.

Please be so kind to check the DB, i suppose that's easy for you.

Thank you in advance

 

[pbaldy]

There is no report in the sample, but I'd expect this line that you already have to work:

DoCmd.OpenReport "Servis", acPreview, , "servis_ID = " & Me.ID

 

[zozoteam]

Dear pbaldy,

I still have a problem, a tried everything but always print all records.

I try to change structure. Please be so kind to check DB now with report.

Thank you in advance

 

[Gasman]

You have to use the correct names for the fields in the table.

DoCmd.OpenReport "Servis", acPreview, , "ID = " & Me.ID

The name is ID in the Servis table. You would have seen that as when you run your version it asks for Servis_ID. That tells you the name is incorrect in this case.

 

[zozoteam]

Thanks a lot!!!!