from reports to form

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....

On Wed, 22 Jul 2009 12:25:14 GMT, norbertbreij wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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" wrote:

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....

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!

Nadihaha wrote:
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

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....

--
Message posted via http://www.accessmonster.com