Getting error from OnClick Macro

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rmch
    New Member
    • Jun 2011
    • 5

    Getting error from OnClick Macro

    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
    Attached Files
    Last edited by NeoPa; Jul 14 '11, 11:08 PM. Reason: Code tags
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    You haven't said what error you're getting.

    Comment

    Working...