Triggering fields with popups to pop up

[Jeff Fried]

I would like to have, in an OnChange event of field #1, a jump to a field #2 that will then activate field #2's popup/pulldown so the list of choices is immediately visible after the user selects the choice on field #1. The popup choices for field #2 will depend on the field #1 choice selected.

I am using the "set insertion point in a field" to jump to the correct field, but it only lands on that field, it does not push the arrow at the right side of the field that will then bring up the list.

Do you know of an Action Script or xBasic command that will bring up the field #2 popup as soon as the field #1 choice is clicked? I searched but couldn't find anything. Thank you.

Jeff Fried

[Tom Cone Jr]

Re: Triggering fields with popups to pop up

Have you tried sending the keyboard shortcut sequence to Alpha Five once focus in the desired field is achieved? Sys_send_keys() might do the trick for you.

-- tom

[G Gabriel]

Re: Triggering fields with popups to pop up

a jump to a field #2 that will then activate field #2's popup/pulldown

You are not indicating what does pop up? is it a lookup table? is it set in field rules? If so, choose "Popup on enterance"

If it is a script, I suppose you could put it in the OnArrive Event.

[Jeff Fried]

Re: Triggering fields with popups to pop up

From Tom:

Have you tried sending the keyboard shortcut sequence to Alpha Five once focus in the desired field is achieved? Sys_send_keys() might do the trick for you.

Tom,

I did consider this, but what keys am I sending? I tried something that sends the {enter} key, but it doesn't pop up. The popup is defined in field rules with pop up on entrance, but I don't seem to be able to pop it up. The idea is to create the equivalent to clicking on the right side arrow. Any thoughts?

Jeff

[Jeff Fried]

Re: Triggering fields with popups to pop up

Gabriel,

It is a lookup table defined in field rules, with "pop up on entrance"? You're suggesting putting it in OnArrive, but what is it that I should put in OnArrive? Bear in mind that I have, in OnDepart from field #1, the achieving of focus on field #2. But then what do I provide that will cause the lookup table to come up?

Thanks.

Jeff

[G Gabriel]

Re: Triggering fields with popups to pop up

If you chose "popup on enterance", it should popup once it gets focus. Are you not getting this result?

[Jeff Fried]

Re: Triggering fields with popups to pop up

Gabriel,

Here's what I have. In field #1, I have an OnChange event set up to "set insertion point" to 1 in field #2. The field rule for field #2 has a table lookup with Popup on entrance set. I guess the question is, does "set insertion point" qualify as an "entrance"? This does not work, so is there another command other than "set insertion point" that you think will work?

Thanks.

Jeff

[G Gabriel]

Re: Triggering fields with popups to pop up

is there another command other than "set insertion point" that you think will work?

field2.activate()

[Jeff Fried]

Re: Triggering fields with popups to pop up

field2.activate() does the same as set insertion point, i.e., it goes to the field but does not stimulate the popup to action.

[G Gabriel]

Re: Triggering fields with popups to pop up

I just tested it, it works fine. I don't know if you have some other scripts that might interfere with that.

[Jeff Fried]

Re: Triggering fields with popups to pop up

Are you entering a new record or modifying an existing? In my case, I'm modifying an existing and want to cover that possibility.

Also, what event are you working with? Is it an OnChange event in the first field? OnDepart in the first field? OnArrive in the second field?

In the table lookup field rule for the second field, I'm sure you have popup on entrance, but do you also have Popup on mismatch for exceptions?

Thanks.

Jeff

[G Gabriel]

Re: Triggering fields with popups to pop up

It automatically pops up on entering a new record, whether you go to field2 by tabing to it or clicking the mouse on it.

On changing an existing record, it will popup if you mouse click to the field, but not if you tab to it.

I am not using any events.

[Jeff Fried]

Re: Triggering fields with popups to pop up

Gabriel,

I'm not worried about how it works when you tab or click. I'm trying to make this happen under program control. This thing works if it's a new record, i.e., the popup happens simply by having it put focus on the second field. My interest is in having this happen when it is in edit mode. This is what I'm having trouble with when using an event, like OnChange, to achieve focus and create the popup.

Jeff

[G Gabriel]

Re: Triggering fields with popups to pop up

here is an example.
Notice the difference if you check/uncheck "display as drop down list box."

Threre was a thread regarding this issue recently.
See if this suits you, if not, my suggestion and always my preference, is to create your own lookup.

[Al Buchholz]

Re: Triggering fields with popups to pop up

Gabriel,

This is what I'm having trouble with when using an event, like OnChange, to achieve focus and create the popup.

Jeff

I think the onchange is too late. What about the onarrive event?