I have a search form in my MS 2K database that retrieves records with selected minimal data in datasheet view. I have added an identifier column that mirrors the primary key field and have made it a hyperlink.(I'm doing this since my primary key is an autonumber field) I would like for the users to be able to click one of the returned records in datasheet view with a hyperlink and go to the applicable record on the form which contains all data.
Currently, I can get to the form by clicking on the hyperlink but it will not go to the specified record. i.e. retrieved data might be primary key field of 37 & identifier field of 37 with name, organization etc. I can click on the 37 in the identifier field and it will take me to the form but it will be on record #1.My hyperlink looks like this 37##Form frmLLDataView