Access refer to Primary Index

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! ?)




Patrick O'DeaAsked:
Who is Participating?
 
AkAlanConnect With a Mentor Commented:
Not sure what you are really needing here. If you include the primary key in the query, you can then use it as the control source for a text box.
0
 
Patrick O'DeaAuthor Commented:
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!)
0
 
Patrick O'DeaAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.