Scroll event???

[BodiKlamph]

Hi,

I'm transitioning from an Excel sheet to an Access dbase.

In Excel the user could "freeze panes", but that doesn't exist in
Access so what I've done is create 2 subforms (continuous forms
view): The 1st one has the first 5 columns and the 2nd one has the
next 20 columns.

Thing is, I want the subforms to scroll together. I've manged to link
them somewhat using the AbsolutePosition property (doesn't work for
new records though; if you have a solution to that then that'd cool,
too).

Ideas?

thx,
Bodi

 

[Guest]

Actually, it is possible to freeze columns in Access.
Position the cursor where you want the columns to freeze, then from the menu
bar select Format and Freeze Columns. Then save the form.

 

[Guest]

The subform wizard will also allow you to connect the subforms so that they
will "scroll" together. Milton Purdy "Golfinray"

 

[BodiKlamph]

Actually, it is possible to freeze columns in Access.
Position the cursor where you want the columns to freeze, then from the menu
bar select Format and Freeze Columns. Then save the form.
--
Dave Hargis, Microsoft Access MVP








- Show quoted text -

Thx for the suggestion. That only works for Datasheet View. I'm
using Continuous Form View

 

[BodiKlamph]

The subform wizard will also allow you to connect the subforms so that they
will "scroll" together. Milton Purdy "Golfinray"








- Show quoted text -

How? Are you referring to the Link Child/Master fields? I can't get
it to do as I need. The records aren't related, per se; rather, they
*are* the same record.