subform updating

[Guest_imported]

I'm new to access and need some help. I created the following:

Table1 -- raw data
form1 -- inputs data into table1
subform -- is Table1

I created "form1" and inserted "subform" which is essentially table1 and shows all the records. I have "subform" unlinked to "form1". What I am trying to do is get the subform to show a new record when I input it using the "form1".

When I save form1 and then return all the data is correct in the subform. How do I get the subform to automatically update when I enter the record?

Thanks for the help.

 

[RickSpr]

This seems an odd design--having the main form and subform with the same Record Source. Normally you would simply allow the users to navigate on the main form. If you want then to see multiple records at the same time, you can just set the form's Default View property to Continuous Forms.

But if this is really the way you want it, what you should do is create an event procedure for the form's After Update event. The procedure needs to requery the subform. If the subform control is named "subform1", the syntax for this is:
Me![subform1].Form.Requery Rick Sprague