How to Requery query result window by keyboard shortcut?

[TheSmileyCoder]

While debugging I often find myself looking at a query or table in datasheet view, while performing other operations in code or form. My problem is that I need to requery the query to see any new records. However atm, I need to close and reopen the query to do so.


Is there any keyboard shortcut to requery a select query or table? (Im thinking something like F5 refreshing page in most browsers)

[beacon]

Have you tried F9 or Shift+F9? This website, http://office.microsoft.com/en-us/ac...003089886.aspx, under the "Keys for working with text and data", it says these will let you recalculate the fields in the window or requery underlying tables.

If nothing else, you can press Alt+R, then press the letter H to use the accelerators to refresh, but I don't know of a keyboard shortcut for refresh/requery.

[NeoPa]

Nice one Beacon :-)

It looks like Shift-F9 is what you're after Smiley.

[TheSmileyCoder]

Thank you very much beacon, both for supplyingthe direct answer to my question, but also for posting that very usefull link.

[beacon]

Always happy to help Smiley! =)

I always try to use keyboard shortcuts for things and just so happened to have that website bookmarked.