FromDropDownValues linked to table

[HansBades]

I am developing a form to enter work orders for building repairs for a company. I have a table of approval codes that are needed for each sku. For instance if a door handle is requisitioned for replacement, there needs to be an approval code. Sometimes, that approval code would be safety and sometimes just cosmetic. I would like a drop down for approval codes for each sku that correspond to the approval code list in the approval code table. I tried to setup a lookup, but the dropdown on the form returns the ID for the approval code rather than the text of the approval code. For instance, it shows ID 1 in the dropdown box on the form instead of “cosmetic”. How can I get the drop down on the input form to show the text values from the approval code table? Thank you.

[Welshgasman]

You bind to that field, but hide that column with a width of 0

[CJ_London]

For instance, it shows ID 1 in the dropdown box on the form instead of “cosmetic”.

assuming your combo rowsource is something like

SELECT approvalPK, approvalName from tblApprovals

set these properties
bound column=1
column count=2
column widths=0

[Welshgasman]

Watch some of these.
Plus other videos on Access there.

https://www.youtube.com/results?sear...=access+combos