How does one refresh a form tothe most current updated data?

[khughes46]

I have some entries that are used by themselves and in combination with each other. After I enter the data and run an update to combine strings I would like to see the update without closing and opening the form. Is there a way?

[June7]

What do you mean by 'combine strings'? Why is data combined?

Code can run Requery or Refresh method.

[khughes46]

As a for instance, I have a school year that is displayed as 2013 - 2014. But I am using these years for predictions for next and other school years like 2014 - 2015.
But to do this I have to add 1 to each current year. I need the years separate for the calculation, but have to display them as 2013 - 2014, so I combine the individual years to form the combined school year.

[June7]

The school year value could be calculated whenever needed.

However, is the issued resolved with suggestion?

[khughes46]

If I store the School Year as 2013 - 2014, how would I do a calculation on that value?

Also, I don't really understand what you meant with "Code can run Requery or Refresh method."

[June7]

I said the "2013 - 2014" string can be calculated when needed, doesn't have to be saved to table.

Code in some event (button Click, form AfterUpdate, etc):

Me.Requery

or

Me.Refresh

[khughes46]

OK, I'll try that.

But to my original question; is there a way to refresh the form (a PF key like F9 does in Excel)?

[June7]

Click RefreshAll on the ribbon or run suggested code.

[khughes46]

Perfect. Problem solved.