Tab focus problem

[cavyman]

On two of my forms I have two tabs (one tab control per form). The
first tab on each form works perfectly, however, when the user clicks
on the second tab and then clicks on a control, the form switches back
to the first tab and saves the record. If the user (still on the same
record) clicks again on the second tab and then on a control, it works
fine. I'm confused! I'm not sure what code to include with this as I
don't know where to start looking for the problem. I'll be glad to post
any of my code if it is needed. Thanks!

 

[Arvin Meyer [MVP]]

Do you have behind those controls to save a record? Or a control from
another form overlaying the second tab? If you have a separate form on each
tab and move off that form after having dirtied the record, the record will
be saved. The only way to eliminate that is to use unbound forms, which
requires significantly more coding.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access