make report work on access db form

I can't open the Zip file - tells me the download is invalid/corrupt.

Note too that BEFORE zipping these up, please do a Compact and Repair on the database.

Also:

Exactly how do we test the database? What forms do we open, which buttons do we click, do we need to enter any text, etc etc. The more information you can give us the better off you'll be.

Scott:I think it is rar archive renamed to zip.
But there are only tables and queries in uploaded DB.

I see ... normally WinZip can figure that out. I changed the extension to .rar but no joy either.

Might just be my machine, of course, and if there are only tables/queries then as you indicate we can't be of much help anyway.

free 7zip and winrar open without problems. It also has 2 linked tables, so I think it is not backend DB.
PS.It is 7zip renamed to zip

Ahhh ... I used 7Zip and it worked!

Still, as you said there are only tables and queries here, so not much to go on.

Typically, a report opened from a form is filtered by some value selected on the form.  So you should check the code from the button or whatever control opens the report, as well as the report's record source.  Try opening the report independently, to see if the unfiltered record source is OK, then step through the code that opens the filtered report, to see where the error occurs.  You might also want to check whether there are any records in the filtered recordset, before opening the report.

helen, did all that and while theren are no records why doesn't it come up as an empty report?

Generally a report with no records will throw an error, but you can avoid that if you place code in the Report's NoData event - something like

Sub Report_NoData()
  Msgbox "There is no data for this report"
End Sub

However, if you still have other issues please UPLOAD THE FRONTEND DATABASE. The one you uploaded is just tables, with no Forms or Reports.

uploaded the front end db
Autotest-forms-indev.mdb
Autotest-forms-indev.zip

@joeloyzaga:
1. You have two backends:
uploaded is only Autotest.db. Can you upload also Autoresults.mdb?
2. Please, explain what exact form should be opened, what should be selected and what button pressed.

if  you use the test scenario form - the button is on the middle menu row next to the export to excel button

You are using "OTA COM Type Lib". Not sure anybody has it. I don't have. So I can't open  Switchboard. Not sure about other forms, but let's try.
Can you give exact name of problem form? If you open it in design mode, in upper left corner you will see form's name:

heres the db
Autoresults1.zip

cant see it on this pc will look at work

Tables seems OK, what about form name (or at least sequence of buttons should be pressed)?

the form is the test suites form and the screen shot of button is attached
test-suites.JPG

I also had that problem which made me think that I could find a working one in the backups - and it did!!!