How to refresh data on a child one-many form

B

Brad Pears

I have a one to many relationship on a form/subform. I have buttons on the
subform that basically will automatically add a new record to the table the
subform is based on.

I am using the sql "insert" clause to add the record - which it is dong just
fine.

However, I have tried the .refresh and .requery commands and neither seem to
be able to display the new record automatically in the list.

I have to exit the screen and come back in before the new record is
displayed.

WHat method can I use to cause the new record to be displayed on the child
form right away?

Thanks,

Brad
 
Top