You say Salt and I Say Sugar!


Wow! Funny sketch on YouTube. I was looking for the song with lyric of “I say potato” when I found it. The song is actually called “Let’s Call the Whole Thing Off!”. It came about because of two things.


The first is related to work and concerns Access 2007 and the difference between the methods Refresh and ReQuery. Borrowing from a post by Richard Rost the following is an explanation of both.

Me.Requery forces the entire recordset (underlying data) for the form to reload. This means ALL of the records in your current form will reload. Your current position will be lost, so if you’re sitting on record 10 of 100, you’ll find yourself back on the first record. Me.Requery is essentially the same as closing and reopening the form. Any new records added by other concurrent users will be available. Likewise any records that have been deleted will disappear. Requery essentially "re-runs the query" that pulled the data into the form in the first place. You can also use requery to update the data in a list box or combo box.

Me.Refresh saves the current record that you’re working on. It will also retrieve any changes (but not additions or deletions) to any records shown in the current form. Any calculations on the form (unbound fields) are recalculated. Refresh does NOT reload the recordset. You do not lose your position in the form (you stay on the current record). Any new records added by other users will not be shown.

If you want to open another form or, especially, a report that contains the data on the current form, you need to issue a Me.Refresh command. I do this in my tutorial when we create the invoice based on the current order. You need a Me.Refresh to save the data to the table so that it will print correctly. You couldn’t use Requery because it will put you back on record 1 of the recordset, which might not be what you want.

The other is thinking about my Mom and a story she told me of how the Russian Language has changed since she was young. When she was in Russian Federation, Tverskaya oblast, Tver visiting with relatives they went shopping. My mom was in a store looking for some sugar. When she could not find any she inquired and they said look for “sand”. So to find сахара look for песок if you are in the Russian Federation.