+ Reply to Thread
Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18

Thread: Form based on table is not populating

  1. #16
    Valued Forum Contributor alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Lake County, Illinois
    MS-Off Ver
    MS Office 2010, 2007 and 2002
    Posts
    1,161

    Re: Form based on table is not populating

    No search criteria entered

  2. #17
    Registered User
    Join Date
    11-07-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Form based on table is not populating

    Thanks again Alan - the code for the no search criteria works well - however one small problem - the query/datasheet window is still popping up in the background.
    I cannot figure out how to stop it from happening.
    Attached Files Attached Files

  3. #18
    Registered User
    Join Date
    11-07-2009
    Location
    australia
    MS-Off Ver
    Excel 2003
    Posts
    79

    Re: Form based on table is not populating

    With this ver of the database I have included the code for the no results found msgbox however this one is not working properly.

    When searching by volume or by rating the button is doing nothing at all.
    When searching by title it shows results however it is still also opening the search query datasheet as well.

    When I deliberately search for something that I know is not in the current list all it does is display the "pls input search criteria" msgbox and also the query window behind it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0