Results 1 to 4 of 4
  1. 04-06-2017, 10:15 AM #1
    maxscott
    maxscott is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    5

    control main form navigation when sub form total does not balance


    I have a main form with a field xvalue.

    I then have a subform - each record has a field iamt. I can sum iamt for related records and this goes into txtSumAmt in main form.

    I want to prevent updates of the main tables if xvalue <> txtsumamt.

    I can stop the update on the main form using a Before Update Event with


    But
    Reply With Quote Reply With Quote
  2. 04-06-2017, 10:26 AM #2
    aytee111
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    But........?
    Reply With Quote Reply With Quote
  3. 04-06-2017, 10:33 AM #3
    maxscott
    maxscott is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    5
    Quote Originally Posted by aytee111 View Post
    But........?
    Sorry - posted before finished. Rookie error!
    Reply With Quote Reply With Quote
  4. 04-06-2017, 10:40 AM #4
    aytee111
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Remove this one - replaced with https://www.accessforums.net/showthread.php?t=65430
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Navigation Form Control: Syntax for Navigation Where Clause
    By Sa'El in forum Forms
    Replies: 3
    Last Post: 10-03-2022, 12:39 PM
  2. Opening popup form makes main tab on navigation form go blank
    By ittechguy in forum Forms
    Replies: 2
    Last Post: 11-22-2015, 07:24 PM
  3. Filtered Combobox form criteria from main form in a Navigation Form
    By ittechguy in forum Forms
    Replies: 8
    Last Post: 09-14-2015, 09:38 PM
  4. Replacing of Running Total from Subform's control to Main form's table's field
    By A Y Khan in forum Access
    Replies: 1
    Last Post: 06-12-2015, 12:03 AM
  5. Data control difference from the form and the navigation control
    By The in forum Forms
    Replies: 2
    Last Post: 11-27-2014, 01:06 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums