Refreshing the main form

[130975]

Hi Everybody,
I am working on a database that creates the Student Code and their email id's.
Table Student stores basic information like First name, last name, address, class etc. Table Email stores Student code, Email Id, creation date. I created a main form from table Student and a command button on it, which opens the Email Form, it takes the value of Student code from the main form and the email id is entered in that form. Tables have one-to-one relationship. In my main form I have created a subform that shows the created Email Id, My problem is that when I create the email id and close the Email form, that created email id is not visible in the main form's subform. It is visible only when I close the form and reopens the particulat code. I have tried the requery method but does'nt worked. Any idea om solving will be highly appreciated.
Thanks a lot in advance.

[missinglinq]

Where have you tried the Requery and what exact code have you used?

[130975]

Hi missinglinq
I have been trying to refresh the main Student Form.
I tried the code

Private Sub Form_GotFocus()
  DoCmd.RunCommand acCmdRefresh
End Sub

It is not working.
I am confused where to use it.
Thanks.

[missinglinq]

To be honest, I'm a little fuzzy as to the ins and outs of exactly what you're trying to do! But, to begin with, Refresh does nothing until the RecordSource has been Requeried! In the code behind the command button that opens up the Email form, place this code on the next line after you open the Email form:

Me.Requery

[NeoPa]

Linq is very much on the right lines. Try :

Private Sub Form_GotFocus()
  Call Me.ReQuery()
End Sub

This is likely to prove expensive on processing unless you only put focus back to the form after your other form closes.
It should still work whatever though.

[130975]

Hi,
Thanks everybody for devoting your valuable time in solving my problem.
I used the following code on close of Email form.

DoCmd.Close
Student.Form_Student.Requery

Once again thank you all.

[NeoPa]

No problem. Glad to see you got a solution :)