SubForm Show History of input

[Mr. Hero]

I have a subform inside a form that is linked to a single table. Everytime I enter a record, the subform isn't showing the recorded entered unless I navigate back to the record entered; even then it only shows one record. I would like the subform to show the records that has been entered. Can anyone please provide me with some guidence in accomplishing this task? Thanks!

 

[ghudson]

You need to requery the subform to display the new record.

 

[Mr. Hero]

Okay, so I would use something like this in the subform VBA?...

Private Sub Form_AfterUpdate()
SubForm.Requery
End Sub

 

[Mr. Hero]

I am able to have it show the last record. How Can I get it to show all the records that I entered for the day?

 

[ghudson]

At the end of the coded event that you use to enter a new record (afterupdate, oncurrent, save, etc?) in your parent form, you need to call the command to requery your subform.

Me.YourSubFormNameHere.Requery

This might help...
http://www.techonthenet.com/access/subforms/refresh.php

 

[Mr. Hero]

Thanks a bunch!!

 

[Mr. Hero]

I have spoken to early :-(.

My form does requery, but all of the records now show. I was hoping the subform would only show the records that I have entered today... Any thoughts?

 

[mixail]

I have spoken to early :-(.

My form does requery, but all of the records now show. I was hoping the subform would only show the records that I have entered today... Any thoughts?

You should create a query and to filter that query as you want and then to show the query in subform.

 

[Mr. Hero]

You should create a query and to filter that query as you want and then to show the query in subform.

Not to say I have tried everything, but I did attempt this. The only thing that I can think that may help is adding another field in my form that records the day, and filtering from this. To be 100% honest I was hoping someone could assist me with my prior post; I really want to be able to display what I had mentioned before, if this is at all possible. Thank you.