Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

VBA Form

Discussion in 'Information Technology' started by pechoi@syr.edu, Jul 28, 2006.

Tags:
  1. pechoi@syr.edu

    pechoi@syr.edu
    Expand Collapse
    Guest

    Hi,
    How can I filter a form in VBA?
    I tried to get a combobox and I entered value in form_load function but
    this doesn't get called Help anyone?
     
  2. Loading...


  3. Barry Gilbert

    Barry Gilbert
    Expand Collapse
    Guest

    I'm not sure what you're trying to do with the combobox, but the way to set
    the filter in VBA is like this:

    Me.Filter = "FilterExpression"

    The Filter expression is like the where clause in a SQL statement. Look in
    VBA help for Filter.

    Barry

    "pechoi@syr.edu" wrote:

    > Hi,
    > How can I filter a form in VBA?
    > I tried to get a combobox and I entered value in form_load function but
    > this doesn't get called Help anyone?
    >
    >
     
  4. PC Datasheet

    PC Datasheet
    Expand Collapse
    Guest

    You have to also set the FilterOn property. The default is False. To set the
    filter in VBA:

    Me.Filter = "FilterExpression"
    Me.FilterOn = True


    --
    PC Datasheet
    Your Resource For Help With Access, Excel And Word Applications
    Over 1175 users have come to me from the newsgroups requesting help
    resource@pcdatasheet.com





    "Barry Gilbert" <BarryGilbert@discussions.microsoft.com> wrote in message
    news:269DD2F8-936F-46CA-BD68-5216F8DAA56F@microsoft.com...
    > I'm not sure what you're trying to do with the combobox, but the way to
    > set
    > the filter in VBA is like this:
    >
    > Me.Filter = "FilterExpression"
    >
    > The Filter expression is like the where clause in a SQL statement. Look in
    > VBA help for Filter.
    >
    > Barry
    >
    > "pechoi@syr.edu" wrote:
    >
    >> Hi,
    >> How can I filter a form in VBA?
    >> I tried to get a combobox and I entered value in form_load function but
    >> this doesn't get called Help anyone?
    >>
    >>
     
  5. StopThisAdvertising

    StopThisAdvertising
    Expand Collapse
    Guest

    "PC Datasheet" <NoSpam@Spam.Com> schreef in bericht news:eAfdg.7485$y4.6316@newsread2.news.pas.earthlink.net...

    --

    To Steve:
    No-one wants your advertising/job hunting here!
    'Resource ???? 1175 users ???? Are you kidding ????
    ==>> You mean that 1175 users have been spammed by you ??

    To the original poster:
    Most people here have a common belief that the newsgroups are for *free exchange of information*.
    But Steve is a notorious job hunter in these groups, always trying to sell his services.

    He is known here as a *shameless liar*, with *no ethics at all*.
    If you provided a valid email address he might even spam you with an offer for payed help

    Before you intend to do business with him look at:
    http://home.tiscali.nl/arracom/whoissteve.html
    Over 900 !! users (rapidly increasing..) from the newsgroups have visited the website to read about this fake 'resource'

    Arno R
     

Share This Page