Recent content by rhino213

Hello! I'm still working on this supplier database for my boss and the supplier filter section is still causing me problems. Let me set the scene for you.... I have a form with 3 combo boxes on it. These are cboProg, cboPPS & cboSupplier. I need to get the combo's working so that when you...

Ok, so this is the code for the form with all the combo boxes on it. Can someone take a look and sanity check it for me please. I know its messy and I've broken some golden rules! ----------------------------------------------------------------------- Private Sub Command9_Click() Me.Filter = ""...

Even better! Thanks!

Scratch that last post! I've cracked that one myself. I've written a macro that closes and then re-opens the form. That seems to clear the filters beautifully.

Cheers mate! :cool: I think I've got that sorted now. Any idea how i could clear the filtering from the form/list? I'm thinking of a little button somewhere on the form that will reset all the combo boxes to display all the records. Thanks again!

I think I understand what your saying but I do have 1 quick question though. I understand how to create a query now using the builder. The control side of things is a bit strange to me though. I have 3 combo boxes in the header of my new form. These are Programme, Primary Product/Service &...

Smart probably has described it pretty well. Pretty well for people that actually have any idea what he is talking about. Remember, I'm a complete Access noob. I can just about muddle through creating tables and forms but when people start talking about creating queries to do all these wonderful...

I'm trying to do the exact same thing but with multiple combo boxes. I've tried to use the method above but it just does not make sense. Could somebody translate it into noob for me please! Thanks!

I've done that and I've got my list. Thanks! But now the subform is not filtering by the selection i make. I choose AAA and nothing happens! :(

The totals query please Ken. I'm guessing you set the row source from the properties box. Thanks!

Could you explain that please. I'm a complete access noob!

Ok! So I've binned the pivot table and gone for a continuos form option that allows the double click event that I'm after. A new problem has appeared. On my main form I have 3 combo boxes (programme, product & company). When I click on any of the combo boxes i get a list of everything in the...

Thanks Rich! Only problem with that is..... It works in form view but not in pivot table view. I'm using a pivot table view because i like the way it allows you to filter the lists. I'm open to other ways of doing this though if anyone can think of any. I'll try to explain myself a bit...

Bump! - Any ideas folks? The boss is on my back now!

Help me! I'm creating a supplier database at the moment. I have a pivot table that allows users to filter the list of suppliers by programme, primary product & company name. I'd like to make it so that double clicking on a company name opens that suppliers details in a new form (which I have...