Refresh data in the forms by close other form

[Kristaline]

Hi there

I am new in vba coding and I have a problem with my data in main form frmMainForm.To enter data to main form I have button to open frmProject form. When I have all data entered and closed frmProject form, data in frmMainForm combo box projects won't update. Anyone can help me sort this problem please?

 

[boblarson]

In the close event of frmProject, you can use

If CurrentProject.AllForms("frmMainForm").IsLoaded Then
   Forms!frmMainForm.Requery
End If

You might need to capture info about which record you are on and then have code navigate because the requery will likely send you back to the first record.

 

[Kristaline]

Thanks Boblarson. It's very quick reply and the code is working!

 

[boblarson]

 

[ajetrumpet]

i LOVE THAT PICTURE BOB