Force an update of record in a subform in Access 2000

Hi all.

I have an embedded form within my main form (subform). This subform is not linked to the main form either ... I do a query action to populate the subform with data that I act on by changing the 1st column to a different value using the column's .Value method. What I want to do is to force the write to the underlying table ... Any ideas on how to do this? (It probably is simple ... ) Thanks!

- Mike

You should use the Refresh method to immediately update an underlying table with data from the form.

The requery method would be used to lose any changes in the form and repopulate the fields with data from the table.

Hope that helps.