Concept is straight forward but coding is something else. Concept: A table containing records with only one field which is the file name of a scaned document. Knowing the path and file name, read that record, display the document, enter selected data from two list boxes and two text boxes, this inputted data becomes the new file name that will be used later for search purposes, then append the new named record to another table used for the searching. I've got it all working exactly the way I want it with the exception i can only read the first recordset record. A loop doesnt work since i have to leave the sub thus loosing track of which record i'm on.I have spent a couple days searching for a solution. The last one explored is the bookmark option. I have not thought that one through but.
Any thoughts will help. I must display the document in order to know what the name should be. The form i am using is bound to the second table and i am working with the dao environment for the input..
Thanks