Requery with Command button

[Bongobob21]

Hi everyone,



I am totally new to this forum and also access in general and I have a small issue I think you can solve easily.
I Created a form in which you can set different parameters Like Zipcode or company name. When all those values are entered you click the command button at it runs a query which will filter the table related to the Dropdown menus or text fields. My problem is that I have to click the refresh button every time I look at the query. is there a possibility with VBA to refresh the Query automatically, when you click the command Button?

thank you and best regards,
Andre

[amrut]

You can requery the individual controls or entire form. Me.Requery or Me.ComboName.Requery

[Bongobob21]

Thank you for your answer but I don"t really know where to put this command.
Mein command button is called RunQuery and the textbox I use is called Zipcode. The Query which will be run when I click teh command button is called qryCustomer and I created the action that the command button should run the query with the query wizard if that changes anything. This is the code I tried in VBA but it doesn"t work.

Private Sub RunQuery_Click()
Me.Zipcode.Requery
End Sub

Sorry I am really at the beginning of using VBA and Access.

[lfpm062010]

In Form Design, right click on the command button and select property (if not shown already).
Find "On Got Focus" (or "On Enter"), and click on the dots, then enter you code (select "Code Builder" and type "me.zipcode.requery"). Should be something like this.

Private Sub Command0_GotFocus()
Me.Zipcode.Requery
End Sub

[Bongobob21]

Unfortunatly it doesn"t work but I also don't get a error message ... Isn't is possible to directly address the query and not the textfield?

[lfpm062010]

Can you provide your db to look at?

Remove any private, confidential, ... etc before posting.

[Bongobob21]

Database4.zip

I hope this will help you! thanks!

[lfpm062010]

You are trying to requery a textbox and not a combo box.
Instead of "On Focus" use "On Enter" instead.

Hope this will solve your issue.

[Bongobob21]

Private Sub Form_Load()
End Sub

Private Sub Zipcode_Enter()
    Me.Zipcode.Requery
End Sub

Private Sub Command12_Click()
End Sub

Still no better result. I am not sure if it is clear what I want, I want to refresh the Query result automatically when you click the command button, so that you don't have to klick Refresh in the Topbar when you are in the query results. Sorry for my bad explanation, I hope I could make my issue more clear now.

[lfpm062010]

You have a "TextBox" and a "Command Button" on the form. You really can't requery a "TexBox".

When I run the form, enter the Zipcode information, and click on the "Run Query" button. It should me a data sheet with the Zipcode selected. It is working fine.

You have to close the query result (Data Sheet) and re-enter your zipcode information and click on the "Run Query" button to see the new result.

[Bongobob21]

Ok because that was my question, whether I can refresh the query without manually closing it? But referring to your statement this is not possible, Thanks!

[lfpm062010]

You can put code in to close the query and re-run them. So, you don't have to manually close it.

I think in the macro is "CloseWindows", "Query" for Object Type, and query name.

[Bongobob21]

Great now it works, Thank you!