Results 1 to 5 of 5
  1. #1
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    Update events from calculated fields

    Just need clarification here. Must be easy!!!



    If you want to refer to a text box in an sql statement (for a combo box) you use where field = text box.

    And use Cbo.requery in the text box onupdate event.

    But what if the textbox is bound to a field. Moving to a new record doesn't fire the onuodate event..

    But I need the cbobox to update based on the record?


    Sent from my iPad using Tapatalk

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    How are you moving to the new record? That could be the event trigger.

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Just the navigation bar at the bottom.


    Sent from my iPhone using Tapatalk

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,511
    Maybe do it on the OnCurrent event of the Form? When you move to a new record this event is triggered.

  5. #5
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Thx bulzie. Helps a lot Will test tomorrow


    Sent from my iPhone using Tapatalk

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

Similar Threads

  1. Use a calculated field to update multiple fields
    By AnneForumer in forum Queries
    Replies: 1
    Last Post: 10-27-2016, 07:05 AM
  2. Update query with calculated fields?
    By shaunacol in forum Queries
    Replies: 9
    Last Post: 07-09-2015, 01:32 PM
  3. Time Validation - Before Update Events
    By pjstrat00 in forum Access
    Replies: 3
    Last Post: 06-12-2014, 03:50 PM
  4. Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  5. Calculated fields going blank after update
    By Monterey_Manzer in forum Forms
    Replies: 3
    Last Post: 10-08-2012, 03:21 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
  •  
Other Forums: Microsoft Office Forums