Goto a specific record

[Danielf]

I have a continuous form based on a query; I would like,when clicking on a record in this form, that it opens a new form- with default view single form- with the "clicked" record in the form.
I have tried
DoCmd.GoToRecord acDataForm, stDocName, acGoTo, me.CurrentRecord
but sometimes it doesn't show the right record.

Thanks for answer

Daniel

 

[simongallop]

Try DoCmd.OpenForm FORM NAME etc.
all details in Help

HTH

Simon