I want to click a button on the main form and refresh the data that is entered in suform. The Focus is still set in the subform, and I want to click the button on the main form to update the subform.
I cannot seem to get my code correct on the button. I have a button on the main form with the following code on click:
[Subform].Forms![Main Form].Refresh (does not compile)
-OR-
Subform.Form.Refresh (does not seem to do anything)
This is not correct, but I do not know what to do to correct it.
I can change a value in the subform, then choose "Records/Refresh" from the tool bar to get the results I want, but not from the button on the main form.
Many thanks in advance,
Ignorance
I cannot seem to get my code correct on the button. I have a button on the main form with the following code on click:
[Subform].Forms![Main Form].Refresh (does not compile)
-OR-
Subform.Form.Refresh (does not seem to do anything)
This is not correct, but I do not know what to do to correct it.
I can change a value in the subform, then choose "Records/Refresh" from the tool bar to get the results I want, but not from the button on the main form.
Many thanks in advance,
Ignorance