+ Reply to Thread
Results 1 to 8 of 8

Need a Help on Filter Using Combo box

  1. #1
    Registered User
    Join Date
    07-19-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    67

    Need a Help on Filter Using Combo box

    Hi

    I am trying to create a Search engine using Combo box and Sub form.

    I have created a database.

    and I enterd the below code in Combo box. but its showing some error.( Syntax error FROM clause)

    Please Login or Register  to view this content.

    please help on this regard.

    I will provide additional information if you need.

    Regards

    Jack
    Last edited by Jack40; 02-23-2017 at 02:34 PM. Reason: spelling

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Need a Help on Filter Using Combo box

    Is that supposed to be an input box?

  3. #3
    Registered User
    Join Date
    07-19-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Need a Help on Filter Using Combo box

    It is a combo box...

    needs to be filter based on combo box value in Subform...

    please let me know if you need any additional information...

    regards
    Jack

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Need a Help on Filter Using Combo box

    Yep, need more information.

  5. #5
    Registered User
    Join Date
    07-19-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Need a Help on Filter Using Combo box

    ok.. Shall I attach the database here??

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Need a Help on Filter Using Combo box

    Hi jack

    You can attach it but make sure that it contains neither sensitive nor huge data.The volume of data should be sufficient enough to apply the solutions on.If you know how to attach file then ok if not please read the method bellow.
    Post a WORKBOOK Scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
    Teach me Excel VBA

  7. #7
    Registered User
    Join Date
    07-19-2012
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    67

    Re: Need a Help on Filter Using Combo box

    Thanks for your information Imran... however I am unable to upload my Access database in the form it is showing invalid..


    now I will explain what am trying to do..

    we have a data which we are using to find the address.. it is having 5 columns./Customernumber/customername/city/state/

    some time we need to find customer name using customer number; some time we need to find number name using customer name.

    we are using this in excel.. however the file is huge we are taking more time to search.

    so am creating a database when I enter a customer number in combo box it will filter automatically the exact values in form..

    I am using the below code in the combo box to retrieve the values in form.

    but its showing some error..

    Option Compare Database

    Private Sub Combo2_AfterUpdate()

    Please Login or Register  to view this content.

    I have attached the screen print of my data base..
    Attached Images Attached Images

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Need a Help on Filter Using Combo box

    Hi,

    It looks as though the CustomerNumbmer field may be text, in which case you need
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. [SOLVED] Filter a Combo Box
    By atdemeo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2016, 03:37 PM
  2. Combo box filter
    By Apollo4life in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2014, 06:43 PM
  3. Combo box filter
    By Apollo4life in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2014, 06:39 PM
  4. Filter using combo box
    By sherlock1241 in forum Excel General
    Replies: 3
    Last Post: 02-09-2014, 08:29 AM
  5. Replies: 8
    Last Post: 12-26-2013, 02:23 PM
  6. Filter using Combo Box
    By 301eco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2012, 10:54 PM
  7. Great Combo Filter/Search form, cant get DATE filter to integrate. HELP
    By fau5tu5 in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2009, 05: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