In a VBA module(function) how do I get the value from a combobox?

[hcsd]

I am working in Access and have created a <font color=red>function</font>. I now need to set a <font color=red>variable</font> in the <font color=red>function</font> to the value of the combobox from an Access form.<br>

 

[jimmythegeek]

Just pass the value.<br>For Example:<br><br>Public Function GetValue(intValue as Integer) as Integer<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetValue = intValue + 100<br>End Function<br><br>On the After Update event of the combo box put the following:<br><b>If Not Isnull(Me.ComboBox) Then x = GetValue(Me.ComboBox)</b><br><br><br>So if the value in the combo box was 25, then you would pass <b>25</b> to the GetValue Function.<br><br>In the Function, the intValue parameter now becomes <b>25</b><br>The function would then return <b>125</b>, so now <b>x = 125</b><br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development