i am very new to access.I have created this macro by watching few examples from different sources in form frmPendingPropo salsUpdate. Getting error when I clicks “new” in field “open” of frmPendingPropo salsUpdate. kindly help me where is problem or if this macro is right
Code:
Action: OpenForm
Arguments: frmContributionRegister, Form, , ="[RegisterID]=" & Nz([RegisterID],0), , Dialog
Condition: Not IsNull([RegisterID])
Action: SetTempVar
Arguments: CurrentID, [RegisterID]
Condition: IsNull([RegisterID])
Action: SetTempVar
Arguments: CurrentID, Nz(DMax("ID]",[Form].[RecordSource]),0)
Action: Requery
Action: SearchForRecord
Arguments: Form, frmPendingProposalsUpdate, First, ="[ID]=" & [TempVars]![CurrentID]
Action: RemoveTempVar
Arguments: CurrentID
Comment