+ 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 2013
    Posts
    256

    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)

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