Hi there,
I have created a number of forms linked to a tables that need to be renamed. When I rename the table I can not go into design mode to change the source table (because it gives an error that the old form is no longer valid). So I open the forms (and code units) in the designer before I rename the form. Then I rename the forms and change the source expression and any reference that is set in the variables of the form to the table.
If I try to run the form now it all seems to work fine except for 1 form. This is a form using a sub form. When I remove the subform control I can run the form without problems. When I insert it again and set the subform properties, the error returns... Am I missing something... or is it ill adviced to rename tables... #-o
Harm
PS: I found out that the problem starts to occur when I set the SubFormLink property.
CANE Microsoft Solutions BV
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl0
Comments
http://www.mibuso.com/forum/viewtopic.php?t=934
If it was hard to write, it should be hard to understand."