Forcing a form to reload

[devonknows]

hi ive got this at the end of my settings page, and i want it show the fmrSearch form change the check1.value, but everytime i do it, it takes two or three attempts for it to change (having to go back into settings and press ok again) so i put fmrsearch.refresh inhope that it would refresh the form and update the Check1.value. but it doesnt is there anywya i can force my form to reload? so it reloads all the form_load values?. please let me know

Kind Regards
Devon,

fmrSearch.Show
If Combo1.Text = "yes" Then
fmrSearch.Check1.Value = 1
Else
If Combo1.Text = "no" Then
fmrSearch.Check1.Value = 0
End If
End If
conn.Close
Unload Me
fmrSearch.Refresh
End Sub
 

[padhuwork]

hi ive got this at the end of my settings page, and i want it show the fmrSearch form change the check1.value, but everytime i do it, it takes two or three attempts for it to change (having to go back into settings and press ok again) so i put fmrsearch.refresh inhope that it would refresh the form and update the Check1.value. but it doesnt is there anywya i can force my form to reload? so it reloads all the form_load values?. please let me know

Kind Regards
Devon,

fmrSearch.Show
If Combo1.Text = "yes" Then
fmrSearch.Check1.Value = 1
Else
If Combo1.Text = "no" Then
fmrSearch.Check1.Value = 0
End If
End If
conn.Close
Unload Me
fmrSearch.Refresh
End Sub
 

you are coding in which form? frmsearch?

"Unload Me
fmrSearch.Refresh"
 

make frmsearch.show and frmsearch.refresh again to see the checkbox being changed.

another way is do it is,
create a module, initialize your form object

Option explicit
Public g_frmSearch As frmSearch
 
Public Sub Main()
Set g_frmSearch = new frmSearch
'which ever form you want to startup put that form name followed show property
ex: frmMain.show
End Sub
 

Set your project property to start in Sub Main()

and in your project replace frmSearch to g_frmSearch

this can for sure get behavior what you are looking for...