Updating Query using Access 2010 with Runtime

[rayape]

Hello,

I have a database with different fields; one of them is the Customer Name. I have created a form to enter the information. In the same form, I have a text box and a command button, which are used to run my query based on the Customer Name. There is no problem with the query when using it for the first Customer Name. However, when I enter a second 'Customer Name' and hit the command button, the query table does not update automatically. In fact, the results from the first query does not even disappear.

I hope I am clear with my question. Could somebody tell me how to update the table irrespective of how many times I run the query?

Thank you!

 

[pyrodie18]

It would help if you posted the code behind your button click.

 

[rayape]

Hi Pyrodie18,

Thanks for the reply.

I don't have any code for the button. I am using the 'Command Button Wizard' that pops up when I draw the button.

This is the first time I'm working with Access. Apologies if there is something I am not explaining well.

Thanks again.