Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

how to make cbo value repopulate a subform

Discussion in 'Information Technology' started by James, Jul 28, 2006.

  1. James

    Expand Collapse

    I've got a combo box, cmd button, and subform. The subform
    automatically lists all records available. I want to use to combo box
    to select a certain user id, then use the cmd button to generate a sql
    statement : "SELECT * FROM audit_table WHERE [ModifiedBy] = '" &
    Me!cboModifiedBy & "'"

    I want the results of that sql statement to appear in the subForm...
    and ideas??? Thanks.
  2. Loading...

    Similar Threads Forum Date
    Sikh Values Blogs Oct 21, 2015
    Jainism Jainism and Sikhism: The Value of Being “Footnote” Traditions Interfaith Dialogues Jul 13, 2015
    World Why do we value gold? Breaking News Dec 9, 2013
    Canada Quebec's Charter of Values: If You Have A Personal Story, Please Share It Here! Breaking News Sep 19, 2013
    Canada Thousands March through Montreal to Protest Quebec Charter of Values (& Video) Breaking News Sep 16, 2013

  3. Svetlana

    Expand Collapse

    Try on click event of your button to apply the filter you want as like
    Forms!NameOfMainForm!NameOfSubForm.Filter="ModifiedBy=" &
    (I suppose that in subform you have a control that keeps the value of
    the combobox in the mainform.)
    Alternative instead of a command button you could use a toggle button
    for every time you want to see all the records together again to turn
    the FilterOn=False.
  4. James

    Expand Collapse

    I keep getting Error 438: Object doesn't support this property of
    I have the subform as a form that is called in (does that make since?)
    So the subform shows up under my list of forms.... The subform box on
    my "AuditTrail" form is called "AuditTrailSubform" and the source
    object of that box is "AuditTrailSubform" ...

    The form AuditTrailSubform is in datasheet view.... maybe i'm just
    going about this wrong... the source for that form is a query statement
    from a table: "Audit_Table"... I'm rather inexperienced, if you can't
    tell, so i'm sorry if this doesn't make since, just send me a msg back
    and i'll try my best to explain more. Thanks.
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page