# Using a Combo Box to Navigate Records in a Form **URL:** \ **Category:** Classic Servoy\ **Created:** [July 27, 2004, 8:38pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346 "2004-07-27T20:38:07Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Zorba](https://avatars.discourse-cdn.com/v4/letter/z/aca169/32.png) [@Zorba](https://forum.servoy.com/u/Zorba)\ **Post date:** [July 27, 2004, 8:38pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/1 "2004-07-27T20:38:07Z")
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 ---
**Author:** ![Westy](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Westy](https://forum.servoy.com/u/Westy)\ **Post date:** [July 27, 2004, 9:45pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/2 "2004-07-27T21:45:30Z")
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](http://forum.servoy.com/viewtopic.php?t=1893) ---
**Author:** ![Morley](https://avatars.discourse-cdn.com/v4/letter/m/7cd45c/32.png) [@Morley](https://forum.servoy.com/u/Morley)\ **Post date:** [July 27, 2004, 11:58pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/3 "2004-07-27T23:58:15Z")
> 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](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? ---
**Author:** ![Westy](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Westy](https://forum.servoy.com/u/Westy)\ **Post date:** [July 29, 2004, 1:54am UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/4 "2004-07-29T01:54:26Z")
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. ---
**Author:** ![Zorba](https://avatars.discourse-cdn.com/v4/letter/z/aca169/32.png) [@Zorba](https://forum.servoy.com/u/Zorba)\ **Post date:** [July 29, 2004, 3:14am UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/5 "2004-07-29T03:14:14Z")
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 ---
**Author:** ![Morley](https://avatars.discourse-cdn.com/v4/letter/m/7cd45c/32.png) [@Morley](https://forum.servoy.com/u/Morley)\ **Post date:** [July 29, 2004, 12:07pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/6 "2004-07-29T12:07:04Z")
> 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](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.) ---
**Author:** ![Zorba](https://avatars.discourse-cdn.com/v4/letter/z/aca169/32.png) [@Zorba](https://forum.servoy.com/u/Zorba)\ **Post date:** [July 29, 2004, 1:09pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/7 "2004-07-29T13:09:17Z")
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 ---
**Author:** ![Westy](https://avatars.discourse-cdn.com/v4/letter/w/9de053/32.png) [@Westy](https://forum.servoy.com/u/Westy)\ **Post date:** [August 13, 2004, 4:29pm UTC](https://forum.servoy.com/t/using-a-combo-box-to-navigate-records-in-a-form/2346/8 "2004-08-13T16:29:38Z")
> 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](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.