<div>
Peter, Thanks, I had thought you could do that but when I tried to use that method to set a parameter directly in an ADODB Command, it didn't work, I had to first declare a variable, then set the variable to the keyvalue, then I used the variable in the Command. <br />
<br />
Does Not work<br />
<br />
Dim cmd as New ADODB.Command<br />
With cmd<br />
&nbsp;.Parameters(@MyKeyValue&quot;) = Me.MyKeyValue<br />
<br />
<br />
Does Work:<br />
<br />
Dim myKeyValue as integer<br />
myKeyValue = Me.MyKeyValue<br />
<br />
Dim cmd as New ADODB.Command<br />
With cmd<br />
&nbsp;.Parameters(@MyKeyValue&quot;) = myKeyValue
</div>


Peter, Thanks, I had thought you could do that but when I tried to use that method to set a parameter directly in an ADODB Command, it didn't work, I had to first declare a variable, then set the variable to the keyvalue, then I used the variable in the Command.

Does Not work

Dim cmd as New ADODB.Command
With cmd
 .Parameters(@MyKeyValue") = Me.MyKeyValue


Does Work:

Dim myKeyValue as integer
myKeyValue = Me.MyKeyValue

Dim cmd as New ADODB.Command
With cmd
 .Parameters(@MyKeyValue") = myKeyValue

<div>
<div class="content wysiwyg-content">
What is the best way to retrieve a rows key value if you include the key field in the query but don't bind it to a text box?
</div>
</div>


What is the best way to retrieve a rows key value if you include the key field in the query but don't bind it to a text box?

MS Access Continuous Form - Retrieve row Key in VBA

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.