Form updating on it's own!

  • Thread starter Thread starter Greg Casper
  • Start date Start date
G

Greg Casper

I have a front-end / back-end situation where the tables reside on the back
end machine and the forms on the front end. When I opened the form, which
allows for simply data entry via some text fields, as I was typing into the
first field, the form cleared! When I checked the tables, the data I had
typed to that point was there... Almost like the back end PULLED the data
from the other machine!

Any ideas on what can cause this to happen?

TIA...
 
Greg,

Check the tab order for your controls, as well as the Cycle property
(located on the Other tab of the forms property window). If the cycle
property is set to all records, then when you type data in the last (tab
order) control on a form, it will automatically move to the next form.

the tab order, at least initially is set by the sequence that the controls
are added to your form. The easiest way to change the tab order is to select
the form, then select View -> Tab Order from the menu bar.

HTH
Dale
 
Dale:

Yes, I know about the tab order. There are about 15 fields on this form. I
was in the middle of the very first one in the tab order... THE MIDDLE! I
never even finished entering the text into that field and BAM! it
disappeared, having been written to the backend tables.

Any other suggestions??

Greg
 
Greg,

Is this on a subform? I have a client whose computer is setup such that if
the mouse hovers over a form or control for a certain amount of time, that
control gets the focus, or in the case of a command button, actually gets
clicked. He has had several instances where his cursor was inside the
subform, but his mouse pointer hovered over the main form for too long and
it got the focus. As soon as the subform lost the focus, that record was
written to the database.

You might want to put some error checking the the forms BeforeUpdate event.
This way, if a field is blank that is supposed to have data in it, the form
will not lose the focus.

HTH
Dale
 
Back
Top