<div>
Milewskp,<br />
<br />
The easiest thing to do would be to use a normal event sub for that event, and have that event sub call your UDF or sub, passing the argument values if need be.<br />
<br />
Patrick
</div>


<div>
Never have seen a way to do that. &nbsp;You need to do code behind control:<br />
<br />
Private Sub cboList_KeyDown(KeyCode As Integer, Shift As Integer)<br />
&nbsp; &nbsp; &nbsp; Call MyFunction(KeyCode)<br />
End Sub<br />
<br />
mx
</div>


<div>
And I assume you mean you want to do this:<br />
<br />
see image ...<br />
<br />
mx<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/05_w21/459754/Capture1.gif" target="_blank" class="file-inline" title="1 (10 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Capture1.gif</a>
</div>


Capture1.gif

<div>
I suppose it is possible to extract the latest Keycode via some Windows API(s) calls, but I don't know what those are off hand ... if they exist.<br />
<br />
mx
</div>


<div>
Can you explain why you want to do this? &nbsp;What should happen when the KeyDown event fires?
</div>


<div>
Hi Helen,<br />
I use a subroutine to set certain properties of most combos of my databases. A function I would like to add in this way is that when a combo box has &lt;=3 items in its drop own list, clicking the spacebar while the combo has the focus will cycle through the list.<br />
<br />
My subroutine automatically adds functionality to my combo boxes by assigning functions to their event properties. This works great if the function needs no arguments, or if the function can derive the argument after it is called, but in this case I'm stuck.<br />
<br />
Something I thought of yesterday is ...maybe the form's keydown event can capture the keycode and save it for later interrogation by the KeyDown event procedure.(?)
</div>


<div>
&gt;&gt; &nbsp;@ <a href="http:#a35771251" rel="ugc">http:#a35771251</a>&nbsp;... is that what you meant - note that does not work - just asking if you want to put the function call on the property sheet ?
</div>


<div>
Hi mx,<br />
&lt;is that what you meant &gt;<br />
Yes, normally that's what I do. 
</div>


<div>
ok ... well, as I do myself. &nbsp;And that certainly works on Events that do not have arguments/parameters ... like say the AfterUpdate event, etc. &nbsp;But in the case of the KeyDown event (et al), assuming you *need* the keycode value (most likely you do) ... then there is no way to grab that value natively in Access.<br />
<br />
So, as I noted above ... your only hope would be to find an Windows API call that could retrieve the last keycode value, then use that in your 'common' MyFunction() ... wherein you could place =MyFunction() directly on the event property sheet.<br />
<br />
I suspect this API call does exist ... <br />
<br />
mx<br />
<br />

</div>


<div>
Has this question been resolved? &nbsp;Can we close the question ?<br />
<br />
thx.mx
</div>


<div>
<div class="content wysiwyg-content">
I would like to set the KeyDown propertyof a combo box to a custom function; eg., = MyFunction(KeyCode).<br />
How can I transfer the value of KeyCode to that function as an argument?<br />

</div>
</div>


I would like to set the KeyDown propertyof a combo box to a custom function; eg., = MyFunction(KeyCode).
How can I transfer the value of KeyCode to that function as an argument?


How to pass arguments to functions called by event properties

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.