<div>
Thanks AkAlan,<br />
<br />
I have not expressed my query well.<br />
<br />
In all honesty I have had a couple of glasses of wine ... and this query is a complex one!<br />
<br />
I will award the points and close the query (for the moment!)<br />

</div>


Thanks AkAlan,

I have not expressed my query well.

In all honesty I have had a couple of glasses of wine ... and this query is a complex one!

I will award the points and close the query (for the moment!)


<div>
<div class="content wysiwyg-content">
I have a generic Audit utility.<br />
I populate a text field with the formname and other data.<br />
<br />
I was wondering if there was any way to refer to actual value of the &quot;primary index&quot; without knowing what the name of the index was.<br />
<br />
I would like to be able to refer to the actual &quot;primary index&quot; value in my audit string. &nbsp;(A sort of form.primaryindex function??)<br />
(As I write this question I am becoming consious that a form could have multiple tables and therefore multiple &quot;primary indexes&quot;. &nbsp; Therefore my query may be impossible! ?)<br />
<br />
<br />
<br />
<br />

</div>
</div>


I have a generic Audit utility.
I populate a text field with the formname and other data.

I was wondering if there was any way to refer to actual value of the "primary index" without knowing what the name of the index was.

I would like to be able to refer to the actual "primary index" value in my audit string.  (A sort of form.primaryindex function??)
(As I write this question I am becoming consious that a form could have multiple tables and therefore multiple "primary indexes".   Therefore my query may be impossible! ?)






Access refer to Primary Index

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.