Refreshing a query!?

  • Thread starter Thread starter marko
  • Start date Start date
M

marko

Hi!
I have a form in which i write data and a query which shows that data.
Now when i have the query opened and i write something in that form the
query doesn't change. I have to close it first and then open it and then it
shows me the changes. Now is there a way that that query could recognize
that data is being inputed in that table and automatticaly refresh. Or can i
refresh (requery) it manually?
Thanks.

Marko
 
I found it SHIFT+F9!
But when i press it then it removes my filters. Can a requery and that the
filtered records stay?
Thanks.

Marko
 
The query will not show the results from the form until the record showing
on the form is saved. To force a record save, use shift-enter.
There are many ways to force Access to save the current record including
refresh and requery but both of those methods have undesirable side effects.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Refreshing a query 1
Query Parameter using multiple options 0
Refresh Table 3
subform will not refresh 6
subform-on Main form not refreshing queried job list 2
Parameter Value error in a Subform 0
How to refresh a single record in a datasheet subform? 1

Back
Top