How to display Record number?

[tarasios]

Hi,

I am running a keyword search query. In addition to the results, I'd
like to display the record number that is associated with the record in
its table so the user can just go to that record in the form. Or allow
them to "click" on the result to go directly to that record.

I'd like not to use VBA but will if nrecessary.

Using Access 2000. Thanks.

 

[Rick Brandt]

Hi,

I am running a keyword search query. In addition to the results, I'd
like to display the record number that is associated with the record in
its table so the user can just go to that record in the form. Or allow
them to "click" on the result to go directly to that record.

Access doesn't have Record Numbers. Or are you referring to the Primary Key value?

 

[tarasios]

No, I am referring to the number in the bottom left corner of the
screen. My PK numbers are customized. Then I could have used that.

I've looked at it some more and what I'd like to do is take the results
of the query and have the user be able to click on it and go to the
corresponding record in the form I am using. Similar to what web search
results do.

I don't know the best way to do this - display the results in a form
with some kind of link to the record or something along that line.

Bet you wished you hadn't asked! Thanks.