[OBP]

Not when there is only 4 records.
But you should be able to use the Sidebar to move around the records.

[maxx_eclipse]

Okay, I fixed the initial problem of the repositioned form, apparently the form size in design view caused the datasheet to be centred, forcing the master view to be moved up.

I'll try adapting the VBA code again and see how it goes. I'll keep you informed.

[maxx_eclipse]

OBP, I copied all the code related to the Form_Click() event for frmECS and sbfrmECS, and I changed all of the variables in my database to the respective forms, but VBA is telling me that:

Run-time error code '3159':

Not a valid bookmark, and then it highlights the following line.

Me.Parent.Bookmark = Me.Bookmark

from the sbfrmECS table

As far as I'm aware, I changed everything correctly and have gone through it a few times now.

But come to think of it, I think I know what the issue is... in the database you sent me, your split form is just a split form, with a main form and the subform (datasheet). In my case, it's a split form AS A subform... I think that Me.Parent.Bookmark has to be changed to something like Me.Subform.SUBFORM_AGENDA.Bookmark... i'll tinker around and see what I get.

I've included a screen print of the actual agenda splitform as a subform.

I'll keep you posted.

[OBP]

I would make the Subform a normal Subform based on the Table or a query, avoiding the Split form all together. I don't think a split form has it's own recordset like a subform does.

[maxx_eclipse]

I'll try tinkering around with the code and let you know how it goes.

[maxx_eclipse]

OBP, I found this page, which looks useful. If I can understand what is exactly done, and which line of code I need to use, I should be able to get the dynamic update working.

http://www.mvps.org/access/forms/frm0031.htm

[OBP]

If you set your Form & Sub Form up the same way that I have in my example the Code that provided should work for you as well.

[maxx_eclipse]

Well, if you refer to my Post #18, you'll see that I'm returned an error. However, I hypothesised why it occurs:

The code for the subform states that Me.Parent.Bookmark = Me.Bookmark

However, because the subforms operate through the main form, the subform2 uses Me.Bookmark (as it has the focus), but since subform1 is RUN THROUGH the mainform, I think I need to change the coding to:

Me![Subform1].Form.Bookmark = Me.Bookmark

I'm still yet to try this out, I'm leaving it till tomorrow to try it out and see how it goes. It's only a hypothesis, I'm only assuming that it could be the solution.

[OBP]

I don't think that will work unless you are trying to set Subform1's bookmark to the Mainform Bookmark.
How come you have 2 Subforms?
Is Subform2 on Subform1 or the Mainform?
Which Forms are you trying to align the Bookmarks on?
Can you post an Example?

[maxx_eclipse]

Subform2 is on Subform1 which is on the Mainform

I've uploaded the database. There is one contact entry, and 2 sample agenda entries.

[OBP]

OK, so I have looked at your Tabbed Mainform.
The Subform_Agenda and Subform_Agenda_Datasheet is working as it should, so what isn't working?

[maxx_eclipse]

Originally Posted by OBP

OK, so I have looked at your Tabbed Mainform.
The Subform_Agenda and Subform_Agenda_Datasheet is working as it should, so what isn't working?

But do the subforms work in the mainform? Or did you look at them seperately? Because on my end, the Subform_Agenda and Subform_Agenda_Datasheet DON'T work in the main form.

Please clarify.

[maxx_eclipse]

OBP,

I had a look at the database you did here (http://forums.techguy.org/6992705-post20.html), which is exactly the situation that I have:

Main Form
> SubForm1
>> SubForm2

And when I copied the code over to my database, I still received the same code issue in the subform2 coding, with "not a valid bookmark" problem. At first, I thought it had to with the fact that my form is pop-up. So as I changed your database, I noticed that it didn't make a difference.

HOWEVER, I've come to propose one final possibility (otherwise I've run out of ideas). I believe the code error is encountered because the "SubForm1" has a master link to the "Main Form", while the database you provided doesn't have any master link with the "Main Form"; your "SubForm1" just sits within the tabbed-form.

So to summarise, this is the difference:

Your sample database (from the post linked above) follows:

Main Form (unbound, not related to any tables)
> SubForm1
>> SubForm2


My database follows:

Main Form (BOUND by the contact information)
> SubForm1
>> SubForm2

...I'm convinced that the "Me.Parent.Bookmark" from SubForm2 conflicts with the 'Master Link' of SubForm1, and doesn't allow the code to execute. So is there anyway in trapping the error and forcing it to continue?

I am also wondering if I should ask people at the Microsoft Discussion Group to see if they could look into this and maybe see if it's a something that can be corrected as a hotfix (IF my hypothesis is to be true).

[OBP]

It is working on the Mainform.
What it can't do is select the second Mainform Record in the 1st Subform as that is not possible as it is not listed due to the Master/Child Link. So the subforms can't control the Mainform Recordset.
But the 2 Subform VBA Links work exactly as expected.

[maxx_eclipse]

Hmm...for whatever reason, it's not working on my end through the mainform. Did you adjust any properties when you had a look?

Also, if I were to change the format from:

Mainform
> SubForm1
>> SubForm2

To:

MainForm
> SubForm1
> SubForm2

Would something like that work? I believe something similar was done here:

http://www.mdbmakers.com/forums/showthread.php?t=23297