By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,692 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Updaing list of names on the subform

P: 13
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
Share this Question
Share on Google+
6 Replies


P: 13
yea i did that but nothing happened. im using ms 2007 too.
Jul 6 '09 #2

P: 13
Its not working still i dont know why.
Jul 6 '09 #3

mshmyob
Expert 100+
P: 904
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

P: 13
@mshmyob
But how would i do it?
Jul 6 '09 #5

mshmyob
Expert 100+
P: 904
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

P: 13
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.