Welcome to SPN

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

Sign Up Now!

Re: Drop Down Menu

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

Tags:
  1. Angel_1

    Angel_1
    Expand Collapse
    Guest

    Hi,
    I have tried and tried but i just cant seem to get it right. It sound so
    simple, i just want to view my records by category in a form. I dont suppose
    you know of anywhere where i could see a example do you please? geetin pretty
    desperate.
    Thanks

    "Angel_1" wrote:

    > Thankyou for your advice i will try this.
    >
    > "Wolfgang Kais" wrote:
    >
    > > Hello "Angel_1"
    > >
    > > "Angel_1" wrote:
    > > > I am trying to display information in a form by using a drop down
    > > > menu to choose which category i want and then the results shown are
    > > > of that category.
    > > > I have tried using a form with a subform and a form on its own with
    > > > no luck. > I cant seem to get the code right.
    > > > Any help would be much appreciated.

    > >
    > > When using a form with subform, add a combo box to the main form
    > > that contains the list of categories and be sure that a corresponding
    > > field is contained in the record source of the subform. In the
    > > properties window of the subform-control set
    > > LinkChildFields: [Name of the field in the recordsource of the subform]
    > > LinkMasterFields: [Name of the combo box in the main form]
    > >
    > > When using only one form, add the combo box (cboCategory) to the
    > > form header and write some code for the AfterUpdate event for this
    > > combo box (something like this):
    > > Me.Filter = "[CategoryID] = " & Me.cboCategory
    > > Me.FilterOn = True
    > >
    > > --
    > > Regards,
    > > Wolfgang
    > >
    > >
    > >
     
  2. Loading...


Share This Page