Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Unanswered: Question about Find (ctrl-f) in bound text box field


    I'm working on an existing MS Access (2003) application that is linked to a SQL Server 2005 database. The forms in Access are bound to specific linked tables based on a value that is selected from an unbound combo box control. There are read-only fields on the form to display data but the Find (ctrl-f) function is still available within those fields to users.

    The question I have is when a user uses the Find (ctrl-f) function on one of the fields does the find search ONLY the data that is currently loaded or does it go back and query the entire table (linked table in my situation) the form is bound to for the presence of the data being searched for?

    Thanks in advance for any help provided!

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    CTRL-F will only be able to find data in the underlying query to the form.

    Why didn't you just TRY IT ? Surely a quick test would be faster than posting a topic and awaiting the answer!
    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