Refresh a table using code

[john134]

I am updating a table using a form/subform to input a new record. After entering the new data in the fields of the subform, I can then open the table, click Refresh All on the toolbar and the new record has been added to the table. However, I want to program this and I have tried almost every permutation of Refresh and Requery code I can think of but I cannot get it to work. I would appreciate any suggestions as to what code to write and what Event to attach it to.



John134

[June7]

Data entered/edited on bound form is committed to table when the form closes, move to another record, or run code to save.

DoCmd.RunCommand acCmdSaveRecord

[john134]

Thank you for resolving my issue. I was led astray by the toolbar Refresh command, which appeared to me that the record had not been saved, whereas it already had been.
One tip: don't leave the table open as you develop the form. It won't display the new record until the table is closed and then reopened. Or, alternatively, if you leave the table open, it is necessary to manually Refresh it to see the new records.
John134