refresh form on open

I have a form that has a subform datasheet this form is used to enter
any problems that my customers have with any of there products
underwaranty.

Once i have entered the products that have broken under waranty in the
subform i have a button that i press that will create a new order.
then i press the button it creats the order number puts the correct
account number on as well.
I have a append query that runs and copys the items in the
frmWarratySubform frmOrderSubform

the problem i have is that when it run it does not display the products
in frmOrderSubform. The only way i can get them to aprear is by putting
a button on the frmOrder with VB code of me.refresh

This then works and dispays the data in the subform


I do not want the button on frmORder with me.refresh. I have tried
putting me.refresh on some of the open properties of the form but none
of this works

Can any one tell me where to put me.refresh so the data dispays
straight away or tell me another way of doing it


Thanks

S.Dickson,

Do you mean that the frmOrder form is already open at the time?
If I understand you correctly.... Try this at the end of the code that
runs the Append Query:
Forms!frmOrder!frmOrderSubform.Requery

--
Steve Schapel, Microsoft Access MVP

wrote:
I have a form that has a subform datasheet this form is used to enter
any problems that my customers have with any of there products
underwaranty.

Once i have entered the products that have broken under waranty in the
subform i have a button that i press that will create a new order.
then i press the button it creats the order number puts the correct
account number on as well.
I have a append query that runs and copys the items in the
frmWarratySubform frmOrderSubform

the problem i have is that when it run it does not display the products
in frmOrderSubform. The only way i can get them to aprear is by putting
a button on the frmOrder with VB code of me.refresh

This then works and dispays the data in the subform


I do not want the button on frmORder with me.refresh. I have tried
putting me.refresh on some of the open properties of the form but none
of this works

Can any one tell me where to put me.refresh so the data dispays
straight away or tell me another way of doing it


Thanks