How can I keep data on form after saving a record?

[RSJohnson]

I have a 5-page tabbed Access form. Except for one, all the controls on the form are bound to fields in the table that the form is associated with. Currently when a record is saved, all the fields on all the tabs are cleared. To reduce the user’s data entry I would like to have all the data on the first page remain the same until the form is closed.

On the second tab, I would like the only the data selected to through a select case procedure to change, the rest to remain as it was for the previous record. There are 6 data collection controls on the second page. Four get their data from combo boxes, one from a selection of an option group and the last from an entry in a text box.

The data on the remaining pages can be cleared each time each record is saved.

Is this possible? If so how would I do it?

 

[Tranman]

The only way I ever found to do that was to create a command button to do the update, and in the event procedure, store all of the values you want to preserve into variables, then plug them back into the fields after the update finishes.

Tranman