<div>
THANKS! I appreciate your help. I know I didn't ask in my original question, but is there a way to select the whole record? Not just the field?
</div>


<div>
The example code provided worked perfectly.
</div>


<div>
<div class="content wysiwyg-content">
Hello. I have a form that displays search results. When the user clicks on a certain record, a macro saves the &quot;ID&quot; value (number) to a TempVar (AccredID_Set).<br />
<br />
I then have a macro that opens a new form showing all accreds of the unit the person selected. I would like to SetFocus on the exact record the person selected in the search result form. (So the person doesnt have to go searching through the records again.) <br />
<br />
I need to figure out how to set focus based on matching the Accred ID of the new form with the AccredID of the old form. (Saved as a TempVar). I am not finding the syntax or where I should stick the code... (On Load?) <br />
<br />
Thanks for the help!<br />
<br />

</div>
</div>


Hello. I have a form that displays search results. When the user clicks on a certain record, a macro saves the "ID" value (number) to a TempVar (AccredID_Set).

I then have a macro that opens a new form showing all accreds of the unit the person selected. I would like to SetFocus on the exact record the person selected in the search result form. (So the person doesnt have to go searching through the records again.) 

I need to figure out how to set focus based on matching the Accred ID of the new form with the AccredID of the old form. (Saved as a TempVar). I am not finding the syntax or where I should stick the code... (On Load?) 

Thanks for the help!



THANKS! I appreciate your help. I know I didn&#39;t ask in my original question, but is there a way to select the whole record? Not just the field?

The example code provided worked perfectly.

How to SetFocus based on a value in a TempVar

Hello. I have a form that displays search results. When the user clicks on a certain record, a macro saves the &quot;ID&quot; value (number) to a TempVar (AccredID_Set).

I then have a macro that opens a new form showing all accreds of the unit the person selected. I would like to SetFocus on the exact record the person selected in the search result form. (So the person doesnt have to go searching through the records again.) 

I need to figure out how to set focus based on matching the Accred ID of the new form with the AccredID of the old form. (Saved as a TempVar). I am not finding the syntax or where I should stick the code... (On Load?) 

Thanks for the help!



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.