Commiting changes on a Form using VB

[Isis]

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

 

[Guest]

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

 

[Isis]

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

Thanks for the info Ken.

Regards