S
S.Dickson
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
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