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.


Dim stDocOpen As String
Dim strMark As String

strMark = Forms!Day0page1.Bookmark

stDocOpen = "Day0Page2"

DoCmd.OpenForm stDocOpen, , , stLinkCriteria

Forms!Day0Page2.Bookmark = strMark

DoCmd.Close acForm, "Day0Page1", acSaveYes

Exit_Day0_12_Click:
Exit Sub

Err_Day0_12_Click:
MsgBox Err.Description
Resume Exit_Day0_12_Click

Thank you all SOOO much for your advice!!!