Updating a form in ms access
The underlying field's value might not be updated before the 'update' event is fired.And, of course, if the control you are dealing with is unbound, there cannot be any field update ...If you right-click on the subform object and select the properties, you should see that there are two subform properties called "Link Child Fields" and "Link Master Fields".
If you want to, you can force an update to the record in the table via the After Update event by using the following: There is a slight conceptual difference between the change of a (bound) control's value on a form and the update of the underlying field's value.I want to know if it's possible to create a form that has read/write access to a very specific (filtered) record set of a table. Create a query which filters the records of a table. Create a form with this query as its Record Source. When I was heavily into Access development I hit this problem a few times.