quote:Originally posted by cco2000
Access will execute the code in the lowest level subform first, which means that the subform (and its code) is probably being executed before the main form has opened/loaded. The quick dirty way of fixing the problem would be to put an âON ERROR Resume NEXTâ statement on the open event of the sub form... not the best solution but it generally works.
If you really want to fix it correctly then you will have to step through the code with the debugger and see what is executing in what order and move things about â possibly by putting certain code on the Current event etc.
There is another method...
You can use the LinkChildFields and LinkMasterFields properties together to specify how Access links records in a form or report to records in a subform, subreport, or embedded object, such as a chart. If these properties are set, Access automatically updates the related record in the subform when you change to a new record in a main form. But, you can still run into another set of problems with using this method â check the Access help files for more.
Good luck dude â isnât Access fun :)
Thanks for the explanation I'll try to fix it correctly and if worse comes to worse the quick dirty way
. I'll let you know; Thanks!!!:)