Hey,
I want to make a querie that sums one combo box in all posts.
But it doesnt work, I've tried copying this, but I can't get it to work!
"Queries cannot "see" any column in a combo box or list box except the bound
column (because the bound column is the value of that control).
Create a public function that gets the value of the column you want and
returns it to the query. For example, in your query, replace the
[Forms]![frm-Name]![combo1].[column(3)] reference with this:
GetMyColumnValue()
Create a public function in a regular module (name the module basFunction):
Public Function GetMyColumnValue(lngColumnNumber As Long) As Variant
GetMyColumnValue = Forms]![FormName]![ComboboxName].Column(1)
End Function
The above example will get the value of the second column."
Does anyone have a clue?
I want to make a querie that sums one combo box in all posts.
But it doesnt work, I've tried copying this, but I can't get it to work!
"Queries cannot "see" any column in a combo box or list box except the bound
column (because the bound column is the value of that control).
Create a public function that gets the value of the column you want and
returns it to the query. For example, in your query, replace the
[Forms]![frm-Name]![combo1].[column(3)] reference with this:
GetMyColumnValue()
Create a public function in a regular module (name the module basFunction):
Public Function GetMyColumnValue(lngColumnNumber As Long) As Variant
GetMyColumnValue = Forms]![FormName]![ComboboxName].Column(1)
End Function
The above example will get the value of the second column."
Does anyone have a clue?