Unanswered: Synchronizing records, multi-page forms
Due to the form size limitation of Access 2k, I decided to use multiple forms linked to a single table, as I am encoding a questionnaire with about 70-80 questions which is spread out over 6 forms.
I tried synchronizing using a filter on the LastName, but that prevents switching to other records without starting over, and when I used the bookmark string it would report "not a valid bookmark" when I switched pages the first time (page1-page2), then it would work fine going forward or back one page. I have tried using various macros and bookmarks to synchronize records but it doesn't seem to work properly.
Anyone know of a simple code or macro so that I can open another form while keeping the same record as the previous form, without filtering?? here is the code I have used so far that doesn't work quite right.