Can Anyone help with the following.
I have a form with 3 subforms onit i have managed to get them to reqeury after they have been updated however the form does not refresh automaticaly to show the changes i have to save close down and then re-open.
I only need each subform to refresh after update and requery.
This is what i have.
Private Sub Status_AfterUpdate()
Me.Requery
Me.Refresh
End Sub
I tired but me.refresh.form1 but that does not work can anyonehelp.
The idea is from the open calls table if i change status to closed the call moves to the closed call table or if i select query it moved the query table each of the three tables data can move between all 3
the form is called form1.
I have a form with 3 subforms onit i have managed to get them to reqeury after they have been updated however the form does not refresh automaticaly to show the changes i have to save close down and then re-open.
I only need each subform to refresh after update and requery.
This is what i have.
Private Sub Status_AfterUpdate()
Me.Requery
Me.Refresh
End Sub
I tired but me.refresh.form1 but that does not work can anyonehelp.
The idea is from the open calls table if i change status to closed the call moves to the closed call table or if i select query it moved the query table each of the three tables data can move between all 3
the form is called form1.
