filter by selection

[scottappleford]

hi

I have serached for the answer but can not seem to find it.

I have a combo box that when a value is selected it finds the record.

I have four fields with one hidden. The fourth selects the lookup in another table and only shows the value. I am unsure how to have it show the project name instead of the id.

Thanks

Scott

 

[ScottGem]

First you don't have fields on a form, you have controls thatg may or may not be bound to a field in a table. This is a subtle but important distinction.

In Any combobox, the display value is the first non zero width column. So if you want the combo to display the project name instead of the ID set the Column widths property to:

0";2"

This assumes that the RowSource of the combo is something like:

SELECT ProjectID, ProjectName FTOM tblProjects;