L
lmv
I have a subform that has TID combobox with source TID and
rowsource
SELECT TerritoryNumbers.TID, TerritoryNumbers.DateCheckedIn,
TerritoryNumbers.Icon
FROM TerritoryNumbers
ORDER BY TerritoryNumbers.TID;
when the choice is made, I want the icon field which has a control source of
=[TID].[Column](2) to display on the subform.
My other field works fine
=[TID].[Column](1) (displays a date)
but
=[TID].[Column](2) which is the icon doesn't work.
I have the icon display on the mainform but it is linked to the table rather
than a query and it shows when another unbound cbobox is selected.
Also, is there a way that a picture shows in datasheet view? (Now it just
says pictuer or bitmap image) I have forms that show it fine just wondering.
Any suggestions? Thank You very much!
rowsource
SELECT TerritoryNumbers.TID, TerritoryNumbers.DateCheckedIn,
TerritoryNumbers.Icon
FROM TerritoryNumbers
ORDER BY TerritoryNumbers.TID;
when the choice is made, I want the icon field which has a control source of
=[TID].[Column](2) to display on the subform.
My other field works fine
=[TID].[Column](1) (displays a date)
but
=[TID].[Column](2) which is the icon doesn't work.
I have the icon display on the mainform but it is linked to the table rather
than a query and it shows when another unbound cbobox is selected.
Also, is there a way that a picture shows in datasheet view? (Now it just
says pictuer or bitmap image) I have forms that show it fine just wondering.
Any suggestions? Thank You very much!