469,167 Members | 2,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Updaing list of names on the subform

I have a form called NewPatient for new patients entry. What i want is that, i need to update or completely refresh the MainForm and it will automatically display in subform1 for the list of patients currently admitted.

I try the requery and refresh upon MainForm_Active() but nothing happen. all i will do is that to press the F5 in order to refresh it completely.


-Thanks for helping-
Jul 6 '09 #1
6 1240
yea i did that but nothing happened. im using ms 2007 too.
Jul 6 '09 #2
Its not working still i dont know why.
Jul 6 '09 #3
mshmyob
904 Expert 512MB
I don't have enough info but I do not think that putting it in the Activate event will do what you want. You will need to put it somewhere else.

cheers,
Jul 6 '09 #4
@mshmyob
But how would i do it?
Jul 6 '09 #5
mshmyob
904 Expert 512MB
Again without more details from you, most often this type of thing would be done in the AfterUpdate event of the form or a control or in the AfterInsert event.

cheers,

@mjworks2009
Jul 7 '09 #6
I figure it out how to. i used the timer event

Private Sub Form_Timer()
If Me.Timer = 0 Then
Me.subform1.Requery
Else
Me.Timer = Me.Timer - 1
End If
End Sub

in this way the subform1 will refresh every second.

Thanks alot for the reply.
Jul 7 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Darryl B | last post: by
3 posts views Thread by Paul T. Rong | last post: by
2 posts views Thread by Elainie | last post: by
1 post views Thread by christianlott1 | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.