Well, you could it in reverse, update the form real fields using VBA which will automatically update the table, won't it?
It is very simple to update the current record fields, which can be on the form but in invisible mode.