Refresh Form

[Oli]

Hi

I have a command button that is opening another form (frm_termchange) and
doing Me.Visible=false

frm_termchange is not linked to any specific table.
frm_termchange performs an update to a record using an SQL command when the
information has been entered and a command button clicked. Also when this
command button is clicked i am doing docmd.openform "frm_Contacts".

However frm_Contacts is still showing the old data. When frm_Contacts is
reopened how can i get it to refresh the data/record?

TIA
Oli

 

[Rick Gittins]

Instead of doing me.visible=false try to close the form using me.close.

Rick

 

[Oli]

Hi Rick

Me.Close is not a valid command....

I'm also passing OpenArgs to the 2nd form....

Any other ideas?

TIA
Oli

 

[Rick Gittins]

Sorry, I was using VB syntax. This will work.

DoCmd.Close acForm, "Form1"

You will need to pass your OpenArgs before you close the form.

Rick