Run Time Error in Datasheet View

[Crispy]

Hi all - I am getting a runtime error when changing a form from form view to datasheet view. The reason it's happening is that I have code in the OnCurrent of the form which populates a text box with information calculated from subforms on the main form. Obviously, with the form in datasheet view, the subform is not there, hence the error.

Any ideas on how I can stop this error from happening?

Cheers

Chris

 

[KenHigg]

One way might be to do a subform that displays like a datasheet view.

???