Using a Combo Box to Navigate Records in a Form

Classic Servoy
1

Hi,

Is it possible to use a combo box and have it to navigate
records within a form? If so, what Method is required to do this?

For example, In MS Access, the option one selects to do this when creating a combo box is:

“find a record on my form based on the value
I selected in my combo box”

Once the user selects the above option, the associated VB script then gets generated and looks something like this:

Private Sub Combo0_AfterUpdate()
’ Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[recordset] = " & Str(Me![Combo0])
Me.Bookmark = rs.Bookmark
End Sub

In example above, [recordset] is the name of the Primary Key.

The combo box can then be used to select or browse records with great speed and convenience.

BTW, this option/feature can also be set in a listbox to do the same thing, only it takes quite a bit of space in a form.

Thanks in advance!

Zorba

2

First, I see this is your first post. Welcome to the world of Servoy. I am sure you will enjoy it.

See the thread “Is it possible a searched combox effect?” at this link and the sample download dynamicValuelist.servoy that is included:

http://forum.servoy.com/viewtopic.php?t=1893

3

Westy:
First, I see this is your first post. Welcome to the world of Servoy. I am sure you will enjoy it.

See the thread “Is it possible a searched combox effect?” at this link and the sample download dynamicValuelist.servoy that is included:

http://forum.servoy.com/viewtopic.php?t=1893

It would appear the dynamicValuelist.servoy sample download is no longer linked to the topic referred to. Is it still available elsewhere?

4

I just tried it and was able to download it. The downloaded file ended in .zip. I had to remove the .zip before I could import the solution. Unfortunately, it is not the solution I thought it was. Maybe someone else can remember were the link is to the sample solution that will help Zorba. I remember seeing a sample solution that demonstrates what he is asking about, but I am not able to locate it.

5

Hello Everyone,

Thanks to Morley and Westy for responding to my reply. My lack of familarity with Javascript/Java is an issue here, but I am happy to report that I am slowly ‘grinding’ my way thru the excellent documentation provided in Servoy.

If anyone does chance upon the code or method as per my initial posting, I would be very grateful if they could post it here.

Thank you in advance.

-Zorba

6

Zorba:
Hello Everyone,

Thanks to Morley and Westy for responding to my reply. My lack of familarity with Javascript/Java is an issue here, but I am happy to report that I am slowly ‘grinding’ my way thru the excellent documentation provided in Servoy.

If anyone does chance upon the code or method as per my initial posting, I would be very grateful if they could post it here.

Thank you in advance.

-Zorba

Hey Zorba, you and me. I’m likewise a babe in the woods, speaking no computer languages other than FMP Scriptwriter which isn’t a computer language at all. So it’s really tough groping around in the dark, stymied at every turn. But it’s getting better, with help from everyone on this forum.

This is very strange.

Earlier Westy referenced the file dynamicValuelist.servoy contained in http://forum.servoy.com/viewtopic.php?t=1893 originally posted by Maarten Berkenbosch. I could see Maarten’s text but there was nothing to download. Just now, a day later, I’ve gone back to the same thread and the file’s there. Very odd. Will take a look.

By the way, these little tip files are just great. Just as years ago learning FMP these techique samples are a fabulous way to begin to think outside the box. I’m far too green at this stuff to offer anything yet in return. Some day.

One final comment about jumping in cold. It’s startling to switch back and forth between FMP (as I must to continue to support running clients) where I’m very comfortable, even proficient, and Servoy where it’s like learning to walk for the very first time. I’m so delighted at the liberty Servoy’s feature set offers and so thankful for this forum where one can ask the most basic of questions and get ready answers. The coaching is most appreciated. Thanks guys. (Seems to be mostly guys so far.)

7

Hi Morley,

Yes, it seems intimidating at first. Looking forward to Servoy’s future potential as a full ‘Java database and application IDE’.

What I find exciting is the JavaBeans plugins feature set. JavaBeans offer portable applets that you can buy/share/exchange and get the job done without ‘re-inventing the wheel’

BTW, do you know of any sources for JavaBeans, either free or commercially available?

Cheers,

Zorba

8

Zorba:
If anyone does chance upon the code or method as per my initial posting, I would be very grateful if they could post it here.

Try the sample permanentSearchFilter download at:

http://forum.servoy.com/viewtopic.php?p=11865#11865

It is a particularly good sample by Maarten that also demonstrates permanent filters.

Morley:
It would appear the dynamicValuelist.servoy sample download is no longer linked to the topic referred to. Is it still available elsewhere?

The problem Morley described may have been caused by not being logged in when viewing the link. Be sure to log in and then view the link. I believe you must be logged in to download sample files.