using VBA to freeze columns

[bdaniel]

Need VBA module to freeze columns when opening datasheet form,i.e., when user opens form, first 7 columns are frozen.

[maximus]

try using this
DoCmd.RunCommand acCmdFreezeColumn on onload event of your form.

please mark the thread solved if this solves your problem