Filters work just fine in subforms - but keep in mind that any filter applies only to the records currently displayed in the subform for the current outer record. For example, if the outer form shows order #1 and the subform shows order details for products C, G, and H, if you apply a filter on H, you'll get just the one row for H for the current order #1.
I suspect you want to apply a filter that shows only the "orders" that contain product "H" - and that requires some code and a subquery filter on the outer form. The filter on the outer form will look like: OrderID IN (Select OrderID From OrderDetails Where OrderDetails.Product = "H") If you want the filter to work in some other way, please let me know. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: martha11ces [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 2:58 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] Re: Lost functions when converting to > Stand Alone version > > > > > John - > > I spoke a little too fast... one of the forms that I want to have a > sort/filter toolbar available for - is a subform. It works when I am > working directly in the subform - but from the parent form - it does > not. I did include the new toolbar in the properties for the parent > form - but that didn't work either. Is there a way to make this work? > There are pretty important reasons why this form is a subform and not > just an element of the parent form - so it will be difficult to work > around it if it has to be changed. > > Any ideas? > > M. Matthews > > --- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > > The basic technique: > > > > 1) Open your database > > 2) Choose Toolbars on the View menu and then Customize on the > submenu > > 3) In the Customize Dialog Box (you are in toolbar edit mode as > long as this > > dialog is open), click the New button on the Toolbars tab. > > 4) The default for a new Toolbar is Toolbar - click Properties and > change it > > to Menu Bar if that's what you want. > > 5) On the Commands tab, find the commands you want to make > available on the > > toolbar or menu bar and add them by draggin and dropping them onto > your new > > toolbar. > > > > You can find all the filter options in the Records group. You can > also grab > > the Custom entry at the top of the File group to create your own > toolbar > > button or menu command. In the On Action property of a custom > entry, you > > can enter a macro name or an equals sign followed by the name of a > Public > > function. > > > > Have fun... > > John Viescas, author > > "Building Microsoft Access Applications" > > "Microsoft Office Access 2003 Inside Out" > > "Running Microsoft Access 2000" > > "SQL Queries for Mere Mortals" > > http://www.viescas.com/ > > > > P.S. The instructions above are specific to Access 97 - the steps > and > > location of some items are slightly different in 2000/2002/2003. > > > > > -----Original Message----- > > > From: martha11ces [mailto:[EMAIL PROTECTED] > > > Sent: Wednesday, March 30, 2005 12:01 PM > > > To: ms_access@yahoogroups.com > > > Subject: [ms_access] Re: Lost functions when converting to > > > Stand Alone version > > > > > > > > > > > > > > > I mentioned Access 97 in the event that creating a button there > is > > > different than in the other versions (possibly limited by some > > > feature). > > > > > > I believe my experience is such that I can create the custom tool > > > bar - however, up to now, I haven't created a button that can > filter > > > a field. I suspect it will either be in code or a macro. Could > you > > > tell me how to do one of the functions? I will then, hopefully, > be > > > able to fill in the blanks and do the others as well. > > > > > > My apologies 4 my lack of experience! I am trying to figure these > > > things out myself... but keep running into roadblocks. > > > > > > Thanks for any help... > > > > > > M. Matthews > > > > > > > > > --- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> > wrote: > > > > It has nothing to do with choosing Access 97. The runtime in > all > > > versions > > > > of Access disable all the built-in menus, but you can put back > > > selected > > > > functionality by creating your own custom menu bars and > toolbars. > > > You must > > > > then set the Toolbar and Menu Bar properties of each form or > report > > > that you > > > > want to use your custom toolbars. > > > > > > > > John Viescas, author > > > > "Building Microsoft Access Applications" > > > > "Microsoft Office Access 2003 Inside Out" > > > > "Running Microsoft Access 2000" > > > > "SQL Queries for Mere Mortals" > > > > http://www.viescas.com/ > > > > > > > > > -----Original Message----- > > > > > From: martha11ces [mailto:[EMAIL PROTECTED] > > > > > Sent: Wednesday, March 30, 2005 9:47 AM > > > > > To: ms_access@yahoogroups.com > > > > > Subject: [ms_access] Lost functions when converting to Stand > > > > > Alone version > > > > > > > > > > > > > > > > > > > > > > > > > Hello All, > > > > > > > > > > I have a problem that others have most probably already > faced. I > > > have > > > > > developed a program in Access 97 (I chose to use it because > > > > > the size of > > > > > the file is much smaller than other versions). When I > > > > > converted it to a > > > > > stand alone product (with Sagekey and Wise) - I lost the > > > functions > > > > > associated with sorting and filtering. > > > > > > > > > > Has anyone already set up buttons with code for functions > > > > > such as sort > > > > > ascending (and descending), filter by selection (and > excluding > > > > > selection), filter for, and remove filter? I would like to > > > > > have a range > > > > > of buttons that accomplish these tasks when the cursor is in > a > > > > > particular field. > > > > > > > > > > I have a 'filter by form' form that works in a run-time > > > > > environment if > > > > > anyone is interested in having that. > > > > > > > > > > Any help would be greatly appreciated, > > > > > > > > > > M. Matthews > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
