W
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?
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?