Results 1 to 2 of 2
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Save Record on subform after update on popup form. Syntax Error

    I have a subform and from there I open a popup form that copies data onto the subform. I just need to make it save the record after the update.


    Main form is CheckRegister and subform is FReg

    I have tried;
    [Forms]![CheckRegister].[Form] = Me.Parent.Dirty = False

    Also as an example I use this code to copy the data from the popup form to the subform and it works.

    [Forms]![CheckRegister]![Check Register].[Form]![startingbal] = Me.startingbalance

    Also tried onclose event: Forms!CheckRegister.Form = Me.Dirty = False
    Last edited by burrina; 02-21-2013 at 12:47 AM. Reason: added code

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    [Forms]![CheckRegister].dirty = false

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Syntax Error For Main Form Subform Report
    By burrina in forum Reports
    Replies: 1
    Last Post: 12-27-2012, 03:03 AM
  2. SQL Update Syntax Error
    By Phred in forum Queries
    Replies: 9
    Last Post: 02-05-2012, 05:56 PM
  3. Syntax Error on Update Statment
    By TinaCa in forum Programming
    Replies: 2
    Last Post: 09-14-2011, 05:53 PM
  4. Syntax error in UPDATE statement HELP!
    By asmith78 in forum SQL Server
    Replies: 5
    Last Post: 09-07-2011, 05:50 PM
  5. Save button say syntax error
    By venu_resoju in forum Forms
    Replies: 6
    Last Post: 02-14-2011, 02:52 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums