Results 1 to 3 of 3
  1. #1
    Greyhound Friend is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    8

    Problem using Navigation Form-Getting error message when using Find button

    I’m new to Access 2010 (and don’t know how to do any programming or use macro functions). I suspect I’m making a simple mistake, but I’ve searched the internet and can’t find a solution. Any help would be greatly appreciated.

    I have a simple form called Contact, which is based on a table called Contact containing several text fields, a web hyperlink, a concatenated field and a button to find records. The form works as expected.

    The problem is that I’m trying to use the same form in a Navigation form I created. When I use the Find button I get the following error message.
    The fields are not searchable due to one of the following:
    The fields are controls (such as buttons or OLE objects).


    The fields have no data.
    There are no fields to search.


    Is there a way to fix the problem?

    Thank you for your time.

    Deb

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Unfortunately, the way to fix this is to not use Navigation Forms and to implement VBA.

    You may be able to get it to work with a Navigation form by using VBA to gather the criteria and then apply it to the Nav form's properties. Functionality outside the properties of the Nav Form is probably unattainable.

  3. #3
    Greyhound Friend is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    8
    Thank you for your reply. Time to get [another] book!

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

Similar Threads

  1. Replies: 3
    Last Post: 10-30-2013, 05:59 AM
  2. XXXXX cannot find the object 'False.' error message
    By LindaRuble in forum Programming
    Replies: 5
    Last Post: 06-17-2013, 02:39 PM
  3. Replies: 3
    Last Post: 07-13-2011, 02:04 PM
  4. Custom error message problem
    By thekruser in forum Programming
    Replies: 10
    Last Post: 10-06-2010, 05:14 PM
  5. Find Record button error
    By Zedlexx in forum Forms
    Replies: 0
    Last Post: 03-11-2009, 09:26 AM

Tags for this Thread

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