problem with locating and moving to a specific record
Posted on 2011-04-24
Have a form to select a customer from a drop down box and then move a main form to that found record. However it is not exactly working. Here is the code i am using:
SET ORDER TO closest ASCENDING
SET NEAR ON
SET NEAR off
This code finds the record i searched for but moves to the very next record. On my main form i simply need to hit a button i have created to move back one in the records and boom, there it is. it is a functional work around but I figure there is something that i am missing in the code to make it stay on the record i was searching for and not going to the next record.