If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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.... |
#2
|
|||
|
|||
from reports to form
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 |
#3
|
|||
|
|||
from reports to form
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.... |
#4
|
|||
|
|||
from reports to form
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 |
Thread Tools | |
Display Modes | |
|
|