General information
Category:
Coding, syntax & commands
Steve:
>
I do a search form and find the record I want as follows.
DO \master\search
When I leave the search form I do the following.
SEEKID = master.incident+master.patnum+master.patqty
SELECT master
SET ORDER TO TAG incident
SEEK SEEKID
mast_REC = recno()
THISFORM.Release
After I return to my find button in my main form I do.
GOTO mast_REC
But I get an error that says, "Record is out of range." and then if I IGNORE the error I get "EOF" message. I checked mast_REC in both places and it has a valid record number such as 4675 both in the search form and after I return from the search form inside of my Find button code.
I tried SELECT master before the GOTO mast_REC, but no help. What am I doing wrong? Thanks.
>
If your "incident" tag expression is just "master.incident", then the SEEK is not successful and thus RECNO() returns RECCOUNT() + 1. GOTO mast_REC raises an error because it is an invalid record.
Daniel
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