Results 1 to 3 of 3

Thread: Unbound field

  1. #1
    Join Date
    Aug 2009

    Unanswered: Unbound field

    I store a calculation in an unbound field. Based on this value another value must be stored in a bound field eg <100 = A; <200 = B etc.but it only updates the bound field once I've clicked on it. Any ideas what I'm doing wrong?

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    I can't be very precise in my answer as I don't know precisely how your application is written, but you could try the Repaint method of the form. There is also the possibility of using the Refresh or Requery method but this is more heavy and resources demanding.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Maybe use Form_BeforeUpdate instead of Object_Click ?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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