from reports to form

[norbertbreij]

Hi, Id like to link from a report to a form. In the report I have an Id that
also is available in the form. I now want to klick on the Id in the report to
go to the origanal form so that it can be edited. What is the best way to do
so? I''ve tryed with a macr but it doesn's seem to work....

 

[fredg]

Hi, Id like to link from a report to a form. In the report I have an Id that
also is available in the form. I now want to klick on the Id in the report to
go to the origanal form so that it can be edited. What is the best way to do
so? I''ve tryed with a macr but it doesn's seem to work....

Sorry, reports are not user inter-active.
You cannot do what you want to do from a report.

 

[Nadihaha]

I can't get this to work at the moment, but you may have better luck than me.
You could try putting in a command button, and tell it to open the form on
click. I don't know the exacts but it may work

 

[norbertbreij via AccessMonster.com]

Nadihaha, thanks for your replay,
I tried the following and it seems to work:

Private Sub Callnummer_Click()
On Error GoTo Callnummer_Click_Err

If (IsNull(Callnummer)) Then
Beep
End If
If (Not IsNull(Callnummer)) Then
DoCmd.OpenForm "Toevoegen call", acNormal, "", "[Callnummer]=" & Callnummer,
acFormEdit, acWindowNormal
On Error Resume Next
DoCmd.Requery ""
End If

Callnummer_Click_Exit:
Exit Sub

Callnummer_Click_Err:
MsgBox Error$
Resume Callnummer_Click_Exit

End Sub

Thank you!