Hi, I am really new to creating user forms but I'm trying to learn via forums and YouTube tutorials.
I have made a form and it has combo boxes. The dropdown is from a table where the biggest list in a column consists of 90 rows. My first dropdown may be a column with only 6 items that I want users to choose from but shows lots of blanks after my initial options. Is there a way to get the drop down to only populate the choices in the column and not populate the excessive blanks?
I have searched for an answer but all of the results relate to data validation lists and don't help my problem.
The 'Other' option should be the last selectable option but as you can see the blanks go on for a long time.
Screenshot 2022-05-25 120540.png
Bookmarks