Access Subreport within a main report problem

[mhegazy]

I have some troubles with my database. I am trying to create a subreport within a main report, I tried this with two different ways. the result is the same in both ways.
Way #1 - In the main report, clicked Subform/Subreport icon and selected the subreport from the list which has been prepared prior.

Way #2 - In the main report, clicked Subform/Subreport icon then built the subreport form the corresponding query, so that the fields I want appeared in the Child fram within the main report.

In both ways, at the run time the database gets panic, and Access shutdown my application database.

Note:
Either main report or subreport is workig individually in good condition viewing the data based on the filter criteria.

Please if you can help on this, I would appreciate very much

Thanks,
mhegazy

[TheSmileyCoder]

RunTime is a special version of access used for running access on a PC that does not have the full package installed.

Please confirm or deny that this is what you mean.

Questions:
Do you get an error message? If so what is the error number and description? If there is error in code, please post full relevant code, and indicate on which line it errors.

How is the subreport linked to the main report?

Have you tried compact and repair?

Does the database contain custom VBA code?

[mhegazy]

Access Subreport within a main report

Thanks for TheSmilyCoder for prompt reply.

Yes sir, I am confirming the descriped problem in my 1st post. Also I have attached two screen shots explaining what happen with me. (See attached: Problem with MS Access.jpg)

Concerning your questions:
1- The subreprot is linked with Date field which is present in the subreport and not appearing in the main report.

2- Yes, I have tried to compact and repair the database, no changes encountered same situation. (See attached: Problem with MS Access #2.jpg)

3- What did you mean with Custom VBA codes?


Thanks
mhegazy

[TheSmileyCoder]

Your description does not seem to match your screenshots. The screenshots seem to indicate you are using a normal version of access and not a runtime version of access. Runtime is something your clients can use without purchasing the full version of access (In which you can develop and modify databases).

By custom VBA (Visual Basic for Applications) I mean code that you (Or someone else) have written in the access database to go beyond the native/built in functionality.

Have you created any macros in your database?

Is this fully your database, or have others taken part in developing it?

In design view, right click the control containing the subreport, and then view its properties, I would like to see whats written in the Link Master Field and Link Chield field properties.

[mhegazy]

Access Subreport within a main report problem

No custom VBA having codes with un-native functionality.
All of them are regular.

No macros in my database.

I have attached a screen shot showing you the Link Master Field and Link Chield field properties.

thanks
mhegazy

[TheSmileyCoder]

I can't really see that there is anything obviously wrong. It could be an Access Error, or a corrupt database.
If it was me, I would probably try the following in the order suggested:
Make sure you have the latest service pack installed.

Try to create a new database, and then import all objects from the old database into the new database and see if that solves anything

Try to run the office installer and selecting Repair (I do believe it has a repair option).

Delete both the main report and the sub report and create both from scratch.

[mhegazy]

I will try and see.

Thanks for the smileyCoder.