MaliciousMike
Registered User.
- Local time
- Today, 20:46
- Joined
- May 24, 2006
- Messages
- 118
Hello,
I have some complex reports which are giving me some real hassle.
The process is this:
In a form, they pull down a report name in a drop down box, then a print button appears.
That button will append all needed records to a table called "tblVisual" using an append query, and edit every record in one column to be the same using an update query.
The report then opens, with the record source as a quesry doing all the mathematics etc.
As 2 of the reports were pretty much the same, i duplicated everything and just changed the query.
I changed the RS of this duplicated report and saved it. When i ran the process, it opened up with the old record source.
When i go into design view and change it, i cannot close the report, or the dabase window, or the forms, or access! Nothing will close at all!!
Really frustrating the hell outta me!
I have some complex reports which are giving me some real hassle.
The process is this:
In a form, they pull down a report name in a drop down box, then a print button appears.
That button will append all needed records to a table called "tblVisual" using an append query, and edit every record in one column to be the same using an update query.
The report then opens, with the record source as a quesry doing all the mathematics etc.
As 2 of the reports were pretty much the same, i duplicated everything and just changed the query.
I changed the RS of this duplicated report and saved it. When i ran the process, it opened up with the old record source.
When i go into design view and change it, i cannot close the report, or the dabase window, or the forms, or access! Nothing will close at all!!
Really frustrating the hell outta me!
