Commiting changes on a Form using VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Isis - 12 Apr 2006 16:26 GMT

I noticed that changes made to fields are only commited to the Tables when
you move off the current record - Cam I commit the changes in VB code ?

Also I have a combo Box that lists records in another Table - when I add a
new record to this Table the combo Box does not get updated until I exit
the form and re display it - can this be done automatically without the
need for closing the form.

Thanks

Reply to this Message

Ken Sheridan - 12 Apr 2006 18:17 GMT

To save the current record use:

RunCommand acCmdSaveRecord
or:
Me.Dirty = False

To update the combo box's list requery the control with:

Me,YourComboBox.Requery

Ken Sheridan
Stafford, England

> I noticed that changes made to fields are only commited to the Tables when
> you move off the current record - Cam I commit the changes in VB code ?
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Isis - 14 Apr 2006 13:02 GMT

=?Utf-8?B?S2VuIFNoZXJpZGFu?= <KenSheridan@discussions.microsoft.com>
wrote in news:20D851B7-EA0A-468B-8F22-D6D9892D8E18@microsoft.com:

> To save the current record use:
>
[quoted text clipped - 19 lines]
>>
>> Thanks

Thanks for the info Ken.

Regards

Reply to this Message