How to trigger F3 during Form Opening?

RachelSoon

Hi All,
How can i trigger F3 (insert new record) during the form opening?
The purpose of doing this is to avoid user to see any record when they open the Sales order. Therefore, i would like to force the system to show no record (untitled - Sales Order) when user open the sales order. The user has to search for the sales order that they wish to access to.

Thank you.

Rachel

Savatage

http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=14045

RachelSoon

Thank Savatage!

After reading from the mbsonline, i understand that there might be additional orders will be created. However, F3 does not actually create the Order until the user hits the Enter key or select the no. series.

The user needs to have a blank order whenever they go into the form. How can i set the F3 at OnOpenForm?

Rachel

Savatage

here's another one worth reading, first...

http://dynamicsuser.net/forums/thread/27430.aspx

as one of the post's state - you could have Sales Order open the Sales List instead of the Card. I don't know the full purpose of the change but these are comments from some very knowledgeable navisioners and they seem to be against such an idea.

allenman

Hello,

I have found this topic in a search.
I have a similar requirement but not relating to Sales Order.

We have deveolped a small Priority Request table and two forms.
A request has been made to make the input form open at new record only, auto F3.

I envisaged an OK, Exit and Delete button. The OK button would give you another blank input form.

I have read the refernced links on this thread but their circumstances are perhaps different.

So please put up with me asking one more time whether this is possible.

Regards,
Steve A

Saro

There is an automation that can help you : 'Windows Script Host Object Model'.WshShell.
There is a command SendKeys in it.

I used it to simulate a next record action (pageup)

WinScHostObj.sendkeys('{PgUp}')

you can use F3 as a parameter then followed by a Return (Enter key)

janpieter

Saro wrote:

There is an automation that can help you : 'Windows Script Host Object Model'.WshShell.
There is a command SendKeys in it.

I used it to simulate a next record action (pageup)

WinScHostObj.sendkeys('{PgUp}')

you can use F3 as a parameter then followed by a Return (Enter key)

And an extra additional tip;

When you create (hidden) buttons on the main form with a shortcut combination; Then you can use sendkeys to press these buttons programatically from the subform.

In my experience that is the way to create the most complex interaction between subforms and mainforms without using automation objects that are not preinstalled.

Saro

I believe you need not install 'Windows Script Host Object Model' automation it's already there.