• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

Access Form Dropdown

There is a table called tblItem. I have a form that is used to fill in a table. For the field “icode” – what do I do so that there is a dropdown that selects only unqiue values from the [iCode] column of table [tblItem]

tHank you
  • 3
2 Solutions
Right click on the control and change it to a combo.

Now fix up a few properties.

Add the table name as the RowSource.
The bound column should default to 1.
Set Limit to List to Yes
Set Allow Value List Edit to No

Switch to the Format Tab

Change the column count to 2.
Set Column widths to:
This will hide the first column since the width is 0 and show the second column.  But the first column is what will be saved to the table since that is the bound column.

If you decide to show more than one column, you probably want to set the Column Heads to Yes and specify an exact width.  Remember, once the dropdown collapses, only the first column will be visible.
RayneAuthor Commented:

 I did it as you aid but I see nothing. Please let me know. I attached the file.
RayneAuthor Commented:
As stated in a previous question: "link keys as combo boxes populated from the linked tables."

Try this for iCode. Do the same for other codes.
RayneAuthor Commented:
awesome hnasr, this is awesome
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.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now