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.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10149-re-drop-down-menu.html
> 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]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10149
> > 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