I've got some problems becouse I'm new in Access:

1) How can I change CommitOnClose property for form object. I want to save record
via command button not with closing window.

2) I have products data sheet form and when user double click selected row program
opens edit form with all product details on it. If user change something after
closing second form, first form is automaticaly refreshed.
But when I append record via second form, the first form doesn't see new record.
I tried to put Me.Refresh in On_Activate, but the record selector goes to top not
on newly added record.

I want to new record be visible in first form and record selector points on it.

3) How can I change color of selected record ?