Update Form dynamically

[ivi77]

I have a button on a form that invokes an update query and updates student's information such as last name, first name, gender, etc, which is got from another table in another DB that is stored in the current DB as a link table. But what I want to do is refresh the form so that it displays the updated information.. I did something like this

Private Sub Image115_Click()
Dim sid As String
sid = Forms!mainscreen![sid#]
DoCmd.OpenQuery "UpdateBasicData"
DoCmd.Close acForm, "MainScreen"
DoCmd.OpenForm "MainScreen", acNormal, Forms!mainscreen![sid#] = sid
End Sub

Can anyone please help me on this.. thank you

 

[FoFa]

What about
Me.Requery

Wouldn't that work?
Or something close to it?

 

[ivi77]

Cool.. thank you..