Update table data

[JP]

I need to update my main table data before I open a
seperate form from the main form. I can enter data all
day long into the main form, but it doesnt save it in the
table until i switch records. However, I do not want to
switch records. I've tried Me.Refresh and several
RecordsetClone functions, yet not luck. Any help or
suggestions would be greatly appreciated! Thanks!

 

[Cheryl Fischer]

You could create a CommandButton on your form which, when pressed, will
explicitly save the current record. From the Design View of your form,
click on the Command Button in the ToolBox and let the Wizard create it for
you.