+ Reply to Thread
Results 1 to 1 of 1

Issue Executing a Search Query with Form - Run-time error 2580

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    368

    Issue Executing a Search Query with Form - Run-time error 2580

    Hello experts, gurus and moderators,

    I'm very new with Access but it seems it's the only way to properly manipulate data which I need to analyse in the future.

    I am currently attempting to execute a Search by using a Form with ComboBoxes under the form: frm_School_Search_Criteria, which includes a sub-form dubbed tbl_School_Search_SB01.

    The idea is that I can choose up to 5 criteria (Diocese, Local Authority, Status Type, Education Phase, and DfE Region) to filter my data.

    All sources of every ComboBox is taken from the corresponding table except for the DfE Region which is extracted from the School Details.

    What constitutes the sub-form data is a combination of data from both the tables School Details and School Trusts.

    Not all 5 ComboBoxes have to be populated but they should be interinked once it's populated.

    I used VBA to execute the search but it came up with the run-time error '2580'..."The Record source Select ..."

    Clearly I believe it's the VBA is where the issue is but cannot resolve the issue to make it work.

    Below is the code I use for executing the search.

    I really appreciate your help and guide please. Thank you.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by rakotonirinas; 08-28-2019 at 12:07 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Form Control Start time & End time button enable or disable in sequence coding issue
    By sboy72817 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2016, 07:05 AM
  2. [SOLVED] Run-time error '1004' when executing Exit Sub command line
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-29-2014, 02:50 AM
  3. Showing Run-time error "1004" when executing code with thousans of data
    By nigel_12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 07:03 AM
  4. Form Button_Exit is not executing at right time
    By foxguy in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-17-2010, 04:36 AM
  5. Error with recordset from SQL query. Run-time error '3704'
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2010, 03:44 AM
  6. [SOLVED] Error 400 on executing macro first time in terminal server
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2006, 05:25 PM
  7. [SOLVED] Run-time error -2147319784 (80028018) when executing a simple macr
    By Jean-Marc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2005, 02:05 PM

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.6.0 RC 1