That's exactly what I'm saying. As long as your form is tied into an updateable record source, then any changes made on the form that are saved (generally by moving to the next record) will be automatically written to the backend data source.Are you sayign taht I don't even need VBA to accomplish this?
Look at your form in design view. Make sure the little box in the upper left hand corner of the form's window has a little black box in it- that means the form object is selected and the properties you see on the properties sheet are for the form itself, not one of its child objects. Look at the Data tab and you will see a property named "Data Entry"- generally it is sixth from the bottom. Set it to True.I looked at the properties of the form and didn't see anything saying "Data Entry" in the Data tab. I was hoping you could be more specific for me.
Let me know if you need any more help![]()