Refresh Data Subform

  • Thread starter Thread starter Ian
  • Start date Start date
I

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?
 
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?
 
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.
 
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.
 
Back
Top