form with lookup field

[gprzytula]

I have a form where i have to fill some data. this data is checked with a table-column and i can drop down the column to see the different values


now i have 2 entries that are similar huwelijksaankondigingen en huwelijksakten
if i type the h it prompts for the first entry, but i would like to have a different shortcut for the second value, otherwise i have to type huwelijksak to be prompted for the second value
or is it possible to assign this value to a funtion key, so when pressing this fk, it enters the second value
thanks for all help/info
best regards, Guy

[jojowhite]

maybe you can make use of Combobox Filter As You Type.
see this demo and open Sales form.
on the form click on Customer combobox and type "h" (do not include the quote)

[Welshgasman]

I just use the down arrow?

[ArviLaanemets]

Simply order the combo's source query by displayed (name, comment, or whatever) field.

Now when you want to select from combo, ...
when you type "h", the 1st selection starting with "h" is displayed, with other selections starting with "h" following in alphabetical order;
when you type "hu", the selection activates from top of list of them starting with "hu";
etc.

At some moment the list of following selections will be short enough to use down arrows (unless you get the wanted entry activated as you typed enough characters for this to happen). Of-course in case you have hundreds or thousands selections all starting with "huwelijksak", then you are out of luck

[gprzytula]

Yes, I understand
I was just wondering if it could be assigned to a function key
but is not a huge problem to type huwelijksak to get the correct value huwelijksakten instead of the first entry huwelijksaan..
many thanks for all info
best regards, Guy

[Gicu]

Please review the attached sample, you can use double-click the combo (after you typed "H" so it selects the first entry) to move to the next entry; the code would advance to the next entry in the list as long as you made an initial selection.
Cheers,

[gprzytula]

thanks for the sample
Guy