subform goes to 2nd record

[jkaester]

I am trying to build a simple table that records outreach information and then have the list update in a subform.

When a new record is added, the form clears except for the username and their ID number so that they can enter another record (if they so choose to.)

My report also works and pulls the data according to the user ID number

Everything work except the subform does not requery to show the updated information but if I click on the control at the bottom of the page I can move it back to record 1 and everything shows. But then the main form fills back up with the data that was just entered.

Whew...

I would just like the subform to "display" the records at this point, I will go in later and add an edit button but that is down the road.

Did I fail to mention they wanted this yesterday? lol

I am adding the database and will take all the help I can get.

 

[jkaester]

the data gets entered into the main form and I want it to just display in the subform.

 

[jkaester]

Hi Pat,
Looking through the forms forum I see that you advise folks not to have the main form update the database and have the records show in the subform.

Could you tell me if the layout of my tables look ok and I will go though and rework my forms.

Thanks for your help

Judy