Event alerts 3 times

[RichyT]

I have set an event on a field update (before update) on a continuous form, that calls a macro, which in turn calls a VBA function, which calls a sub procedure. The sub seems to work fine, but when I enter some invalid data, the error message appears as many tmes as there are records on the form.

I believe this may be due to the fact that the text box which is updating the field will have the same name as the corresponding text boxes for all the other displayed records. Can anyone please help.

Cheers

Rich