refresh form on open

[Simon]

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

 

[Guest]

try this in the on open event:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

 

[Simon]

Thankscould not get this to work

could you just expain what the code does,

I am new to VB code

thanks

 

[Guest]

I was just guessing at a resolution to your problem, sorry it didn't work.
It is difficult not fully understanding how your data is set up and related.

The code I gave you calls the "refresh"menue item.

When you have your form open looking at the menu bar across the top you see
an item for "records", expanding this gives you the "refresh" item the code
calls.

Sorry I am no help

 

[Guest]

Maybe you can place the code after your line calling the append query????