Question Access Userform Help

[redrabbit]

Hi all,

I have used Access before but mainly building queries on an exisiting data but never from scratch. Currently, I have setup a shared workbook in excel for approximately 25 people to use at the same time but as it is a shared workbook, people are hiding columns and sometimes Excel can have performance issues at the least. I have been looking for an alternative to this and thought about using Access.

Where I am currently, is that I have managed to import my data into Access and build a table and mess about with the userform.

I want to add the functionality of drop down option on a particular field (s) which then displays the records. How is this possible?

Red

 

[maxmangion]

Hi and welcome to the forums.

What you are looking for are called combo boxes. If you want to select values from these combos and the data will be added to your table you should search about "bound combo boxes"