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)
3 results in 0.0037 seconds.
-
How to Requery query result window by keyboard shortcut?
-
How to Requery combobox in subform based on unbound parent form listbox
I have a combobox on a subform that is based on an SQL that uses a listbox on the unbound parent form as the criteria. When the form is first loaded, it works perfectly, limiting the dropdowns to only those associated with the listbox. However, when I update the listbox, I cannot get the combobox to requery. I've tried requery AfterUpdate on the listbox control, AfterUpdate on several subform controls, as well as trying to requery the combobox... -
How to Requery a control in a form
I have created a form that has a few combo boxes on it. On the form I
have ComboBoxA which selects data from a region, and ComboBoxB that
selects individual locations within a selected region. I need to
figure out the correct way to Requery ComboBoxA after I have updated
it. I searched the archive for this list and found a simple solution:
put Me.Requery in the AfterUpdate event of ComboBoxA. However, when
...
