Recent content by MCOwen

Yes, I'm changing the Recordsource and not the Sourceobject property. In desperation I rebuilt both forms from scratch and it now works. Not sure what to make of that other than there must have been a "problem" with one or both of the original forms.

I have a main form which allows the user to "filter" the data in a subform in datasheet view (it actually creates a custom sql and updates the subform's Recordsource property). I have set up two events in the datasheet sub form: a Form Dbl-Click and a Dbl-Click on one of the columns/controls...

Bob, Thanks for the info. Unfortunately I've not been able to get either to work in my case. I get a message that the database can not be opened because its open in exclusive mode by another user. I have the databased open in shared mode. I still don't understand why the RunMacro works...

I've looked through the past threads and none seemed to provide any insight to my situation. I'm new to the OutputTo command. I first tested it with a standalone macro. Once working, I created some code to execute the macro from a form with the database window hidden. The macro worked fine...

From Popup/Modal forms I have several command buttons each to Print Preview a specific report. Each report is opened using DoCmd.OpenReport rptName, acPreview, , , acWindowNormal. In each report the last statement in OnOpen is DoCmd.Maximize and the last statement in the OnClose is...