Solved

Access Form Dropdown

Posted on 2014-01-13
5
415 Views
Last Modified: 2014-01-13
Hello,
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
howDoesThisLook2014-3.accdb
0
Comment
Question by:Rayne
  • 3
5 Comments
 
LVL 34

Assisted Solution

by:PatHartman
PatHartman earned 75 total points
ID: 39777522
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:
0;2
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.
0
 

Author Comment

by:Rayne
ID: 39777653
Hello,

 I did it as you aid but I see nothing. Please let me know. I attached the file.
howDoesThisLook2014-2.accdb
0
 

Author Comment

by:Rayne
ID: 39777657
0
 
LVL 30

Accepted Solution

by:
hnasr earned 425 total points
ID: 39777660
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.
howDoesThisLook2014-4.accdb
0
 

Author Comment

by:Rayne
ID: 39777702
awesome hnasr, this is awesome
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now