Commiting changes on a Form using VB

  • Thread starter Thread starter Isis
  • Start date Start date
I

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
 
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
 
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
Click to expand...

Thanks for the info Ken.

Regards
 
Back
Top