Hello Mike.
Now suppose the operator is scrolling around in the list box showing the "fullphonenumber field" ordered on "phonenumber" and she is on recno() = 142. Now she wants to change the order of the file to "address". The click event stores the recno() as 142 then routes her to another list box with sourced with the same cursor but showing the "address field" and ordered on "address". I want the cursor in the new list box to open with the highlight on the recno() = 142.
Are you telling me that the table you are pulling the data from does not have a Surrogate Primary Key? That is how you should do it - make the bound column of the combo box the column that holds the PK. Then, all you need to do is set the combo's value and you are finished.
Of course, if you are not using surrpogate primary keys, this should be a lesson to you < s >. Things are much easier when you do set up your data correctly. If you do not set up you data correctly, everything else becomes difficult.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only