Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Location
    Teas
    Posts
    28

    Unanswered: The OpenForm action was cancelled.

    The OpenForm action was cancelled.

    You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box.

    For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box that asks if you want to save the changes you made to the form.
    =============================================

    Hello everyone,

    Thanks for taking the time and sharing your experience.

    a: I have attached the database.
    b: Please open frmgroups
    c: Click on "Click here for Plan Matrix"
    d: I am getting an error message
    e. my goal is to pull up the form called "frmPlanMatrix"
    f: form should be pulled by ga_record_id_2
    h: If "GA_Record_ID_2" does not exist in the tblPlanMatrix then It will
    create one record with the "GA_Record_ID_2 " id
    g: if "GA_Record_ID_2" exist in the "tblPlanMatrix", then the system
    should only pull the correct record "GA_Record_ID_2".
    i: How do i put a drop down box from another table which reflects
    the true value in the tbl_groups. or change it.

    Thank you very very much.
    Dianna Michelle
    Last edited by cool_guy_no_1; 05-15-03 at 18:11.

  2. #2
    Join Date
    Jan 2004
    Location
    MA
    Posts
    1

    Re: The OpenForm action was cancelled.

    Originally posted by cool_guy_no_1
    The OpenForm action was cancelled.

    You used a method of the DoCmd object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box.

    For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box that asks if you want to save the changes you made to the form.
    =============================================

    Hello everyone,

    Thanks for taking the time and sharing your experience.

    a: I have attached the database.
    b: Please open frmgroups
    c: Click on "Click here for Plan Matrix"
    d: I am getting an error message
    e. my goal is to pull up the form called "frmPlanMatrix"
    f: form should be pulled by ga_record_id_2
    h: If "GA_Record_ID_2" does not exist in the tblPlanMatrix then It will
    create one record with the "GA_Record_ID_2 " id
    g: if "GA_Record_ID_2" exist in the "tblPlanMatrix", then the system
    should only pull the correct record "GA_Record_ID_2".
    i: How do i put a drop down box from another table which reflects
    the true value in the tbl_groups. or change it.

    Thank you very very much.
    Dianna Michelle
    Hi Dianna

    Did you find a fix for this error? I have a customer who has the same error and I was wondering how to fix this problem.

    Look forward to your reply.

    Thanks,
    Felix
    Last edited by fjfirenze; 01-29-04 at 11:41.

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: The OpenForm action was cancelled.

    Originally posted by fjfirenze
    Hi Dianna

    Did you find a fix for this error? I have a customer who has the same error and I was wondering how to fix this problem.

    Look forward to your reply.

    Thanks,
    Felix
    Put the line:

    On Error Resume Next

    before the call to the OpenForm (or for that matter OpenReport) call. This will suppress the error message ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •