Refresh data displayed in subform

[Tom McMillion]

I created an "Order Entry" form with a subform on it
called "AllOrders subform" displayed in datasheet mode.
The purpose of the subform is to display all orders
including new orders added to the "Orders" table using
the "Order Entry" form.

I need a command button to refresh the subform to display
additional orders created on the main order entry form.
I figured out have to move the focus to a subform, but I
haven't figured out how to update the subform to display
additional records from the underlying "Orders" table
from which the subform was created.

Any advice or comments?

 

[Shawn]

-----Original Message-----
I created an "Order Entry" form with a subform on it
called "AllOrders subform" displayed in datasheet mode.
The purpose of the subform is to display all orders
including new orders added to the "Orders" table using
the "Order Entry" form.

I need a command button to refresh the subform to display
additional orders created on the main order entry form.
I figured out have to move the focus to a subform, but I
haven't figured out how to update the subform to display
additional records from the underlying "Orders" table
from which the subform was created.

You can create a macro associated to the button
that "requery" the subform when pressed.