Hide filtering capability in a subform

[larryo]

I have created a Subform within a Form, and set it up so that the Subform
displays in a datasheet view. I have found that when the Form and Subform
are in 'Form' view, others who are entering data, see the down arrow in the
column heading name of the Subform, and frequently click on it, thinking that
it is a drop down menu, when in fact, it is the control for the filter. This
causes some confusion. Is there anyway to hide that filtering down arrow
when in 'Form' view, with disabling the filtering capability when both the
'Form' and 'Subform' are in datasheet view?

 

[Jay974]

Hi Larryo

I might be wrong im my thinking, but have you tried setting the enabled value
on the subform to No and the locked value to Yes?