view new records in the form

[ranen]

I do have a form with fields new and number, everytime a new records will be added in other form, the records should appear in my form. can you please help. i tried to requery the tables and refresh it but nothing is happening.

 

[ranen]

the records are actually save after it has been added in the table and i'm adding records from other form. and i don't know where to the code. i put codes on afterupdate and its working fine but the problem is the new cases is not appearing. thank you for the response

 

[Bat17]

Ranen
Are you applying the requery to your form? you will want a button for it.
Sub btnReQuery_Click()
me.Requery
End Sub

Peter

 

[ranen]

i have tried all the requery and refresh in my form but nothing happens.

 

[ranen]

i tried every event for the form i started from on current, nothing happens, gotfocus, afterupdate. just because i don't have any button to click. so i want it automatically, or let say when someone updates the form, new records will appear or remove. Thank you so much for the endless help. hope i can solve this.

 

[ranen]

Thank you , Pat and Peter for answering all my questions. I already solved it with being unaware of other events. Thank you very much