How to Update Changes of Form to Table

[Gary]

I have a table (bounded to the form) with all the fields placed in a Form.

When I make a change to fields in the Form, the value is not transferred to
the Table until I use the navigation button to advance it my form to the next
page.

I tried move the table one forward and back, but that didn't do anything
(VBA Code).

Can someone tell me how I can have the changes of the form updated to table??


Thank You,


Gary

 

[John W. Vinson]

I have a table (bounded to the form) with all the fields placed in a Form.

When I make a change to fields in the Form, the value is not transferred to
the Table until I use the navigation button to advance it my form to the next
page.

I tried move the table one forward and back, but that didn't do anything
(VBA Code).

Post your code. It should have done.

Can someone tell me how I can have the changes of the form updated to table??

A Macro with a Command action, with SaveRecord as the parameter; or in VBA
code,

DoCmd.RunCommand acCmdSaveRecord

or, more obscurely but equally effective,

If Me.Dirty Then Me.Dirty = False

 

[John W. Vinson]

How to update a table with form

Fathi, you're talking to real live human volunteers, not to a search engine.

Normally a Form will have a "Recordsource" - this can either be a Table or an
updateable Query. The Controls on the form would be bound to fields in the
table; typing into a textbox, checking a checkbox, selecting a row from a
combo or listbox will all write data into the Recordsource table. No code or
macros needed; that's just how forms work.

Here are some resources to help you get started:

Utter Access discussion forum and resources:
http://www.utteraccess.com

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com