Need help with report (1 Viewer)

Z

zozoteam

New member

Local time

Today, 05:04

Joined

Oct 27, 2017

Messages

3

• Oct 27, 2017

• #1

[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

 

Attachments

• DB01.accdb

  1.3 MB · Views: 97

Last edited: Oct 28, 2017

pbaldy

Wino Moderator

Staff member

Local time

Today, 05:04

Joined

Aug 30, 2003

Messages

36,125

• Oct 27, 2017

• #2

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

 

Z

zozoteam

New member

Local time

Today, 05:04

Joined

Oct 27, 2017

Messages

3

• Oct 28, 2017

• #3

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

 

Attachments

• DB02.accdb

  460 KB · Views: 98

Gasman

Enthusiastic Amateur

Local time

Today, 13:04

Joined

Sep 21, 2011

Messages

14,262

• Oct 28, 2017

• #4

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

Code:Copy to clipboard

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.

 

Last edited: Oct 28, 2017

Z

zozoteam

New member

Local time

Today, 05:04

Joined

Oct 27, 2017

Messages

3

• Oct 28, 2017

• #5

Thanks a lot!!!!