I have a form with two subforms. Parent is sourced to a query and both subs are sourced to a table. Each sub has same Parent-Child data link. OnLoad code on the parent filters one sub alphabetically A_H and other J_Z, (“H” is actually a field on the Parent, controlled by the user). The majorButtons on the parent actuate code transfer and import data from excel.
All works well in A2007, but bombs out in 2003 with “not Working” message whenever code is triggered. One trigger for error was any refresh statement-I removed those. In A2003 just clicking record Refresh from the menu causes the “--Not Working" message.
If I remove the filters from the two subforms, or remove the parent-child link from one of the forms, all works well. The only way I can get the code to work is to close the form with the first line of code, then reopen it when code is finished.
Can someone tell me what is going on? I skipped from A2000 to A2007, so don’t have much experience with A2003.
I am using W7 for both computers. The A2003 computer is a 32 bit machine, the other is 64 bit.