Need help with a report

[jukus]

I have a very simple database that allows you to enter a workorder, it auto numers the workorder, select the property (by combobox), select employee (by combo box), date, desription of work, and unit number. I am wanting to add a button to the form that pulls up a report. the problem is not the button but the report. I am having trouble creating a report that pulls only the current info in the form. I have a form and it pulls all of the work orders and print the in the details part of the report.

My query is probably wrong or I have went about this wrong. Any help is greatly appreciated. I can attach a sample database if I need to.

Thanks again.

 

[ajetrumpet]

My query is probably wrong or I have went about this wrong. Any help is greatly appreciated. I can attach a sample database if I need to.

Please do.

 

[jukus]

Here is the database. On the enter workorder I am wanting to add a button to preview a report that draws the current info. I set up a query for this, but when I do a report it places all of the work orders in the body of the report. I erased the report, due to frustration. Thanks for any help

 

[ajetrumpet]

Here is the database. On the enter workorder I am wanting to add a button to preview a report that draws the current info.

If you're talking about opening a report to view the record that is in the form (frmWorkOrders) at the time you push the button, then look at the new file I uploaded. You don't need to create a query for this. Just write a command behind the button (you can use the form's table as the basis for the preview)...

 

[jukus]

this is very close to what I want. I may need to change my tables a little.

I really want to set up the report to include the name and address of the property and the name of the employee. I wan the items in my query to be in the report. I may need to change the table to include these. I am new to this and this is my first attempt at a database and it can be frustrating.

Thanks for the help.