Update or Requery button

[azhar2006]

Hello everyone
I am trying to add an update button after adding data to a subform. But I want the place or location of this button in the main form

 

[DHookom]

The code depends on the name of your subform control. It might be something like

Me.[your subform].Form.Requery

 

[arnelgp]

what do you need to Update?

 

[Pat Hartman]

But I want the place or location of this button in the main form

That won't work.

Why?
Because Access automagically saves the subform record when you move focus from the subform to any control on the main form so by the time your code in the mainform runs, the data from the subform has already been saved.

So, the question becomes what are you trying to do or prevent that you can't just let Access automatically save or don't want to put the save button on the subform?

 

[azhar2006]

That won't work.

Why?
Because Access automagically saves the subform record when you move focus from the subform to any control on the main form so by the time your code in the mainform runs, the data from the subform has already been saved.

So, the question becomes what are you trying to do or prevent that you can't just let Access automatically save or don't want to put the save button on the subform?

Thanks a lot for the reply
I know. Access saves the data as soon as you move to the next field. What I want is to refresh the form because there is an unstructured field where the sum of records is calculated and another field that calculates the sum of vacation days. I can't see that unless I close and open the form or go back in the records.

 

[DHookom]

Thanks a lot for the reply
I know. Access saves the data as soon as you move to the next field. What I want is to refresh the form because there is an unstructured field where the sum of records is calculated and another field that calculates the sum of vacation days. I can't see that unless I close and open the form or go back in the records.

So, did the suggested code work or not?

 

[azhar2006]

So, did the suggested code work or not?

No it didn't work

 

[CJ_London]

What does ‘didn’t work’ mean? You get an error? Nothing happens?

Where are the two calculated controls? Main form or subform? What is the controlsource to these two controls?

 

[theDBguy]

What I want is to refresh the form because there is an unstructured field where the sum of records is calculated and another field that calculates the sum of vacation days. I can't see that unless I close and open the form or go back in the records.

Try this code for your button.

Me.Recalc

 

[DHookom]

Thanks a lot for the reply
I know. Access saves the data as soon as you move to the next field. What I want is to refresh the form because there is an unstructured field where the sum of records is calculated and another field that calculates the sum of vacation days. I can't see that unless I close and open the form or go back in the records.

Why couldn’t you mention your requirements in your first post?

 

[Pat Hartman]

Access saves the data as soon as you move to the next field.

No. That is incorrect.

 

[azhar2006]

Try this code for your button.

Me.Recalc

Thank you very much Sherk. The code worked fine.

 

[theDBguy]

Thank you very much Sherk. The code worked fine.

Glad to hear you got it sorted out. Good luck with your project.

 

[Gasman]

Thank you very much Sherk. The code worked fine.

Sherk????

 

[azhar2006]

Sherk????

I have been following since 2018, he knows what I mean