Access dropdown menu in tabular form column

Hi

In my Access tabular form shown below I want users to be able to select a Part number from a drop down menu that gets its data off the Parts table.
How do I do this?

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
NorieConnect With a Mentor VBA ExpertCommented:
Murray

There are 2 options really, both done in design view:

1 Select the Part No textbox control, right click, goto Change to.. and select combobox.

2 Select the Part No textbox control, delete it, add a combobox control in it's place.

With option 1 you would need to amend the properties, e.g. RowSource, etc, of the combobox yourself, with option 2 you should get a wizard that will guide you through the process of setting things up.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.