I am trying to create multiple copies of the same report for several

Clients.  I have a report designed that has no record source defined.  I

make a copy of this report to another name (either in a VB code module

or manually) and when I try to update the record source property of the

report (again, either in VB code module or manually) Access just seems

to freeze.  I get no error message.  If I am running VB code, it never

comes to an end.  If I am attempting to change the report manually in

design mode, as soon as I select the query I want for the record source,

the hourglass appears and nothing else ever happens; I no longer have

control of Access no matter what I do or how long I wait.  I have used

this method many times before (even for creating versions of this same

report) and this is the first time I have encountered this problem.  ANy

ideas?

Sounds like corruption--have you tried a compact & repair?  How about

copying all your objects into a fresh db--does everything come over okay?



-Roy



-----Original Message-----

From: Diane Roberts [mailto:Diane.Roberts@c...]

Sent: Thursday, August 16, 2001 9:03 AM

To: Access

Subject: [access] Problem setting record source for a report





I am trying to create multiple copies of the same report for several

Clients.  I have a report designed that has no record source defined.  I

make a copy of this report to another name (either in a VB code module

or manually) and when I try to update the record source property of the

report (again, either in VB code module or manually) Access just seems

to freeze.  I get no error message.  If I am running VB code, it never

comes to an end.  If I am attempting to change the report manually in

design mode, as soon as I select the query I want for the record source,

the hourglass appears and nothing else ever happens; I no longer have

control of Access no matter what I do or how long I wait.  I have used

this method many times before (even for creating versions of this same

report) and this is the first time I have encountered this problem.  ANy

ideas?