Results 1 to 2 of 2
  1. #1
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59

    Calculated field doesn't updates only after form record Save

    My main form opens a form in Data entry mode. (with: DoCmd.OpenForm "ItemAddNew", , , , acFormAdd, acDialog)
    I enter data in the form ItemAddNew.
    I click save button.
    Before save it calculates a field:
    Me.Code = Me.S_cbo.Column(5) +1 '''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''' '''' calculation of the Code, which is bound to field 'Code'.
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 ''''''''' save


    The text box doesn't have methods or anything...

    Edit: I changed the text box's name to field's name and it's ok now, my mistake.

  2. #2
    llkhoutx is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Try a form requery after the calculation, to update the form recordsource. The form should be updated without the requery.

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

Similar Threads

  1. Replies: 17
    Last Post: 02-15-2014, 01:13 AM
  2. Replies: 3
    Last Post: 10-08-2012, 08:40 AM
  3. Replies: 2
    Last Post: 01-09-2012, 08:15 AM
  4. Save Changes - inconsistent updates
    By 161 in forum Queries
    Replies: 1
    Last Post: 03-19-2011, 03:16 AM
  5. Replies: 2
    Last Post: 03-29-2010, 11:52 AM

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