Hello,
I have few fields that show up in datasheet view on a form. My first field has dropdown boxes with selections that user can choose. Based on the selection, I'd like some columns to hide or show.
For example, if user chooses "Work Type A" from my first column, Columns H thru J will hide and therefore, only allow user to fill information in the the showing columns.
I want to do this becaues there are a lot of work types users can be working on that each have their own set of fields to fill out so I only want the ones that apply to that work type to show.
Thank you in advance for your help!