Scrolling in subforms?

[CompAnalyst]

Alrighty, I am feeling like an idiot. I have a series of subforms which corolate to months (don't ask its a silly way of doing it but its what the client wants ) and the subforms happen to be quite long... so when i tab through, the form itself doesn't move. I have to manually drag the form's verticle scroll bar. Its kinda annoying for data entry. I can't figure out how to fix it!

In the subforms i have made it so u can't add records (due to primary key issues), but I don't see how that would affect it.

Sigh.... it's always the little things that make it irritating.

Thanks any and all who can help.

 

[RoyVidar]

I'm not 100% sure I understand the question, you want scrolling, but how much at a time?

One dea would be to create up/down buttons using the .absoluteposition property, for instance something like this for a "down" button:

[tt]if me.recordset.absoluteposition + 9 >= me.recordsetclone.recordcount then
me.recordset.absoluteposition = me.recordsetclone.recordcount-1
else
me.recordset.absoluteposition = me.recordset.absoluteposition + 10
end if[/tt]

For an "Up" button, test same test, but than that the absoluteposition -10 >=0 (0 is record number 1)

Or just assign the absoluteposition 0 or recordcount - 1.

- is this what you're after?

Roy-Vidar

 

[CompAnalyst]

hmmm... basically what i want is for the MAIN form to scroll with the SUBFORM. Does that make sense? At the current moment what is happening is that i am entering data and tabing through the subform, and the view or position on the main form is remaining the same. Make sense?

 

[RoyVidar]

Now I understand what you mean, but I don't know any way of doing that programatically, I'm afraid. Might be possible, lets see if someone else has a clue.

Roy-Vidar