Save Record without navigation or closing

[ViRi]

Hi

I have a form with a button and a text box

The control source for the text box is a Number field called FileNo in a Table called File. THe default value of the text box is 0.

When the button is clicked a value is calculated using the last value under FileNo in the Table.

The problem is that I have to either navigate the records or close the form in order to save the new value onto the Table.

I need to be able to save a new value to the Table as soon as it is generated without having to close or navigate. So that I get some new value everytime I click the button without closing the Form.
(when the button is clicked 1 will be added to the last value under FileNo on Table File)

ViRi

 

[addy]

In your coding for the button's OnClick event - add this line after the code has updated the text box with its new value:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[ansentry]

If you are using 2000 or later ( I think that it's only 97 you can't use this)

If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord
End If

instead of:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[ghudson]

The DoCmd.DoMenuItem commands have been outdated since Access 97!

Check these threads out on some of my methods to enhance your application.

A Better Mouse Trap?

Another mousewheel solution

Enable/Disable The Control Box X Button

Hide all Access Toolbars and Menubars

Audit Trail