continuous subform refresh

[Blackwidow]

right I have searched and searched the forum but obviously this isnt as simple as I thought it would be!

I have a main form called "frmAllStudents" based on a query called "qryAllStudentsMainScreen". The unique field in all forms is Admission Number.

I have on this form a data-entry subform called "TeachingAssessment" where a member of staff puts in teaching Assessment.

I have a second continuous subform called "previousTeachingAssessment" which lists all the previous teaching assessment.

The problem I have is that unless i select another student or open and close then the previous teaching assessment doesnt update. How do I requery to get this to show on the continuous form?

 

[Len Boorman]

Basically all you need is a buoon that has an Event provedure attached to the On Click property.

The Event procedure will call a requery

the syntax is something like Forms![Main Form Name].[Sub Form name].requery

This process could also be called from an event on your add data subform but it could be a little tricky finding a suitable event. If you have a save data button then the event could be added so that it is called after the Save

Len

 

[Blackwidow]

thanks that worked perfectly!

I think i'd tried practically every other example i could find this morning!

 

[Len Boorman]

If you know how to do something then it's easy.
If you don't then it's hard.

The bit in between called learning is just painful at times but some will say knowing what doesn't work is as valuable as knowing what does,

Not totally sure about that one

Len