Creating dynamic hyperlinks

[mattellenburg]

I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record.

[John_G]

Hi -

If you are using docmd.openform, the fourth parameter on the Openform command allows you to specify a Where condition to limit the records the form displays. You can accomplish what you are trying to do by using a where condition that specifies only the one record you need:

DoCmd.Openform MyForm, , , "Record_ID = " & Me![Search_record_ID]
MyForm is the name of your data entry form,
Record_ID is the name of the field in your table that uniquely identifes each record, and
Me![Search_record_ID] is the name of the control on your main form that contains the ID .

HTH

John