Subform data refreshing

[WBullock]

I have a main form for an Interview and a sub form for Interview details
which is the many side of the relationship. I have a table that has
interview questions in it. What I do is an append query that is attached to
a button in the subform. This appends the questions into the interview
detail table. Howevery when I run the macro that is attached to the button
the subform doesn't refresh. The append query works and the data goes into
the underlying table but doesn't bring it into subform. Is there a way to
refresh the data in the subform without having to press F9?

 

[Jon Furman]

You could use VBA to explicitly force the refresh of the subform by calling
the requery method of the subform control. You could also try to use either
the Requery or RunCommand actions in a macro if you want to stick with
macros. Between these two options I'm pretty sure that you can acheive what
you're looking for.

Jon

 

[WBullock]

I tried both by attaching them to the on click property of the button I
push. THis happens after the append query runs. The form only refreshes
when I manually press the F9 button.

What am I doing wrong?

 

[WBullock]

I finally got this to work in vba using the requery method. THank you