I have written some code that creates a dynamic datasheet form which is based on a crosstab query.
Can anyone tell me how I would go about using this form as a subform on another form. Is it possible to 'mount' it on a form which was created in the usual way (ie manually in form design view) or does this form have to be created in run time by code as well. If code, could anyone suggest how I might do this.
Also, does anyone know if it is possible write code to carry out the operation Format / Freeze Columns on a datasheet form on a specific known column / field name.
Can anyone tell me how I would go about using this form as a subform on another form. Is it possible to 'mount' it on a form which was created in the usual way (ie manually in form design view) or does this form have to be created in run time by code as well. If code, could anyone suggest how I might do this.
Also, does anyone know if it is possible write code to carry out the operation Format / Freeze Columns on a datasheet form on a specific known column / field name.
