Freezing columns in forms

  • Thread starter Thread starter Luther
  • Start date Start date
L

Luther

Hi,

I have a query that produce a continuous form; what I
would like to do is have the first 2 fields frozen (like
Excel freeze panes!!) so that the user can ALWAYS see them
as they scroll to the right to make changes.

Any help would be appreciated.

Thanks,
Luther
 
You can freeze the columns by selecting the column(s) then right-clicking
and select freeze. They will remain frozen each time you open the form
until you change the property.

Damon
 
Notice that I said the results of the query are displayed
in a CONTINOUS FORM, not a datasheet. Thanks
 
hmmm, i've never had to do that....but you might try using two subforms,
both bound to the underlying query, with the main form unbound - just a
holder for the subforms. the left subform could be just wide enough for the
two columns, and the right subform could take up the rest of the width of
the main form. you'd have to synchronize the subform records, and do some
tweaking to get a fairly smooth user experience. for data entry, there'd be
issues such as the timing of when a record is saved - because "leaving" a
subform saves the added/edited data in the current record. all in all, it
might be a workable solution for your needs, but it'll take a fair amount of
effort to implement.

hth
 
Back
Top