refresh problem

[PayeDoc]

Hello All

I have a split FE/BE A2K mdb where the FE has a form with two subforms and
various textboxes and other controls. One of the buttons initiates an append
query and then has the line:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
This is the command code that was generated when I used the wizard to create
a refresh button, and I added it to the event procedure of my button so
that, after running the append query, the subforms and textboxes would be
all refreshed. My problem is that this line works fine on some PCs but on
others it hangs forever (only ctrl-alt-del gets me out) - even though all
the PCs have identical FEs. How can that be? Is there a better way of
refreshing the subforms and textboxes?

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Damon Heron]

After Access 97, domenuitem was replaced by runcommand - look up runcommand
in help and see the various acCommands that are available - ? I never use
these commands myself, just a VBA requery method. See Help.


Damon

 

[Leslie Isaacs]

Hello Damon and Alan

Many thanks for your replies. I am sure I will be able to get the info I
need from the links you've given, but unfortunately I'm away from the office
for a week now so will be unable to do anything until after that. I will
post back here with the results!

Thanks again
Les