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-

re: Updaing list of names on the subform

Simple Form.Requery does the thing - at least in Access 2007.

Remark: You don't need to substitute something instead of "Form", write it as is.

re: Updaing list of names on the subform

yea i did that but nothing happened. im using ms 2007 too.

re: Updaing list of names on the subform

There can be the problem because of entering new record, which can be not inserted to database in fact.

Try testing it on some existing record, not on creating a new one.

re: Updaing list of names on the subform

Its not working still i dont know why.

re: Updaing list of names on the subform

Can you share and MDB to take a look?

re: Updaing list of names on the subform

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,

re: Updaing list of names on the subform

But how would i do it?

re: Updaing list of names on the subform

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,

re: Updaing list of names on the subform

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.