Automatic Update Feature of Forms?

[mkc80]

Hi,

I have a form and an associated table. The data that is entered in the form automatically gets entered in to the table without a save button (I don't know how)
How do we turn on or off the auto save feature?

Also, the table should only contain unique rows. For example, say my table has 3 fields, UserID, Name and Address.
Say, I have only entered UserID and Name today and come back tomorrow to fill the same form with the same UserID, Name but now will update an address.


What is happening is, a new record is being created instead of the first record just getting updated with the address information.
How do I stop this (Are there any features/properties I can set in the form to just update it OR write VBA code)

Please advise.

[June7]

The data is saved to table because data controls (textbox, combobox, listbox, checkbox) are bound to fields of the form's RecordSource (the associated table or query). The entries are committed when the form closes, move to another record, or run code to save. There is no 'switch' to turn save on/off. Controls are either bound or not bound.

If you want to update an existing record, need to pull up that record from the table. The form will open to the first record of its RecordSet. So need to do filter or search to go to desired existing record. Can use the intrinsic Access search/filter utilities or write code to build custom user interface. Code can be macros or VBA. The more customized the GUI the more code is required. Review http://datapigtechnologies.com/flash...tomfilter.html

[mkc80]

Thank You, this helps me get an idea of what needs to be done!