switching to datasheet view corrupts data

[Guest]

This is a strange one. For unrelated reasons, in my form's Current event, I
set the focus back to Surname (Me.Surname.SetFocus). Unfortunately, when the
user switches to datasheet view (and also switching back to form view),
whichever column happens to be on the left gets its contents copied into the
Surname field - seriously embarrassing as my client has lost a lot of
surnames over the last month!

I'm getting around this now by remming out SetFocus line but I'd love to
know what the problem is - any ideas?

 

[Guest]

You are not giving enough information to give much help. Don't allow the user
to switch to datasheet view, keep it in forms view.