Hi Strive4peace,
I used your recommendation on a form and it worked very well. Is there a similar parameter configuration for a look up on a table? I am getting the same issue, only can see the “ID number” and I only need to see the “text name”
thank ypu for your reply
Isac
hi Isac,
you're welcome! wonderful, thanks for letting me now.
> similar parameter configuration for a look up on a table?
not exactly sure what you're asking
... to reference a column of a combobox value, use
=me.controlname.column(#)
in ControlSource of another control such as a textbox
... to specify that the first column with the ID number isn't what shows in the combo, in the ColumnWidths, set the first column width to be 0 (zero);
... if you want to display a SAVED value in a table, you can use a domain aggregate function in the ControlSource of a combo ( =dSum(...), = DFirst(...), etc )