VBA Forms - Suppressing User-Prompt Screen

[dea965]

Hi,
How do I suppess the display of the "generic" user-prompt screen when I am using a VB form to prompt the user to enter values for a report?
I am using a VBA app with a form that prompts the user to enter a firm number and a set of dates. After the app accepts the form, the system displays the "generic" user-prompt screen with the same values (pre-populated). That screen is redundant and does not need to be displayed.

Any ideas would be appreciated. Thanks in advance,
Dave A...

 

[blom0344]

Hello Dave,

Unfortunately I have no solution right know, try the VBA section of the following forum:

http://www.forumtopics.com/busobj/

I am interested in the code you are using to generate the VBA form in Busobj. would you be willing to share it?

Thanx in advance... T. Blom
Information analyst
tbl@shimano-eu.com

 

[pabloj]

In a similar case (setting prompt variables and refreshing from VBA) I've just put:
....
Application.Interactive = False
Document.Refresh
Application.Interactive = True
...

this prevented the usual refresh prompt to appear.
Hope this helps!
Stick to your guns