Using A2003. I'm receiving this error when returning from a
"DoCmd.OpenRepo rt..." statement. I have a tab control with a subform
on every tab. The user selects an item from a combobox at the top of
the main form which refreshes all the subforms. If this DoCmd
statement is not executed, then I don't receive the error. I tried a
"DoCmd.OpenQuer y..." instead of a report but get the same error.
I want the user to be able to print-preview a report if they try to
delete an item from any combobox on the subforms where there are
related records. They're given an option to print-preview a report
showing the related records. If they choose to print-preview, then
this error occurs on trying to move to another record. If they choose
not to print-preview, then the error doesn't occur.
It appears to be something with the DoCmd property. I'm finding some
posts on this newsgroup about getting this error after deleting
records and being careful about how subforms are linked. If there are
no related records, then the item is deleted and I'm able to go on to
another record. The subforms refresh just fine if the DoCmd is not
executed.
Any help or advice on how to fix or work-around this problem is
appreciated.
"DoCmd.OpenRepo rt..." statement. I have a tab control with a subform
on every tab. The user selects an item from a combobox at the top of
the main form which refreshes all the subforms. If this DoCmd
statement is not executed, then I don't receive the error. I tried a
"DoCmd.OpenQuer y..." instead of a report but get the same error.
I want the user to be able to print-preview a report if they try to
delete an item from any combobox on the subforms where there are
related records. They're given an option to print-preview a report
showing the related records. If they choose to print-preview, then
this error occurs on trying to move to another record. If they choose
not to print-preview, then the error doesn't occur.
It appears to be something with the DoCmd property. I'm finding some
posts on this newsgroup about getting this error after deleting
records and being careful about how subforms are linked. If there are
no related records, then the item is deleted and I'm able to go on to
another record. The subforms refresh just fine if the DoCmd is not
executed.
Any help or advice on how to fix or work-around this problem is
appreciated.
Comment