Save record on Tab Form change

[JohnB]

Hi. I know that this should be in the Forms Coding section
but I cant see it cos of the upgrade to this site. Also,
please excuse if I dont reply promptly - my capability to
see the various sections changes daily.

I am using a Tab Control form as the main Switchboard in
my db. Each Tab displays a different form. I believe a
record would normally be saved when a form is closed but I
think forms stay open when you move between Tabs. Is there
a way I can ensure that a record is saved when the user
moves away from one form to another by clicking on the
others Tab? Are there any disadvantages to doing this?

Thanks, JohnB

 

[Guest]

The record is saved the moment you leave the record, not when the order closes,

When you move to another tab you are leaving the record and its being saved
at that point

 

[JohnB]

Thanks for this.

Perhaps I misunderstood my users but I thought they had a
problem as follows. They update a record, then with the
cursor last left in one of the records fields, go to
another Tab and click on a command button that links to a
Merge document and the recently updated record does not
show.

As I say, perhaps my mistake. Ill have a play around with
this.

Thanks again, JohnB