Acces07 - Textboxes not displaying results after query

[whitesabbathica9]

I have a form where the user selects start and end dates in textboxes. The query (after hitting a button) sums data in 8 fields, resulting in 1 row, 8 columns of data. I have 8 corresponding form textboxes linked to these fields.

My problem is the form does not update the textboxes as the query is run, but only continues to display what the query's values were upon opening the form (before the dates wer input).

How can I refresh the form's textboxes? Or is there a better way than binding the textboxes to the query's fields? I am an Excel guy and am just getting started with Access and would appreciate any help/tips. Thanks.

 

[jackd]

You could try Me.requery in the Button's Click event, after the code that does the SUMming.

 

[whitesabbathica9]

Works great!
Had some trouble figuring out how to get the code from the MacroBuilder to the VBE, but I made it. Thx for the help.

 

[jackd]

You're welcome, good luck with your project.