Refresh Data Subform

[Ian]

I have a main form with a subform that I've build a
append query for. Whoever is entering the data clicks
a "hot button" which lets them add a bunch of services to
a subform in the main form. The problem is that it
doesn't automatically refresh the data. I've added a
button (command30_click) that refreshes it on the main
form and my append query is started by a macro. Is there
a way to "click" the refresh data button as the last line
of the macro?

 

[Steve Schapel]

Ian,

Try a Requery action at the end of your macro.

 

[Guest]

I added in the requery but I keep getting the message
"the is no control named... in the current field". If I
leave the control source name blank in the requery field
nothing happens.

I think the problem is that the focus is on the append
query that is adding the items not on the main form?
Maybe I need to change the focus back to that form?

 

[Guest]

more food for thought. I used the open form at the
beginning then the requery and that did it but it takes
it back to the first form.

 

[Steve Schapel]

Ian,

It depends where the macro is being triggered from, i.e. which event on
which form/subform. I am afraid I am not sure what you mean by "the
focus is on the append query", and I am a bit lost as regards your form
structure and what you are really trying to achieve... it seems a bit
unusual. But there is a GoToControl macro action that may be relevant
if you want to change the focus.