Recent content by Costinu

Don't know. 2007 i think. What is the latest version ? Also, is it possible to have a search box with pictures ? For example to have two colums and in the left to write "Laptop" and in the right to have a picture with a laptop. And if that is possible, to make it work like this: if you click...

@MajP The last one you sent me gives me an error as well: Access can't open the file 'filter sector' When i click debug it sends me to the same line .add Me!Command37, "id" May be from my Access version ... or some settings i have.

Access cannot open the file command 37. When i click debug it send me to this line .add Me!Command37, "id"

@arnelgp Thanks for your support in soving my problem. It is a different approach indeed, but the filters need to be filled in a specific order, you cannot skip one. @MajP Your last file seems to do the trick, i got us to the fact that after i select a value from the filter i need to double...

@MajP Thanks again for helping. The only reasons I wanted to understand what I am doing are: - to be able to make modifications - for example toadd a fourth combo box for example or another field ... and know that i need to add another line and where. - to actually manage to learn from you guys...

@theDBguy i understand now what you meant by if - do something - end if. very neat and clean ... doesn't compare whit what i have done with the code @MajP thank you for the tip. i will certainly have multiple looks in that. because i don't know very much how to code, i tend to see what others...

If you have the time and an easier way to do it (so i can also learn something from the modifications you are making ) it will be much appreciated. The cascading combo box from @MajP uses modules / macros and i barely know VBA.

@theDBguy Thanks again ! Not sure how i can make this work: "That should be easy to do. Start out with a subform with an empty RecordSource or one that doesn't return any records. You can then update the RecordSource from your filters." Can you please help me out a little ? Regarding If - do...

@MajP Thank you so much for helping. The solution you sent makes it work in any way i select the filter boxes - just what i needed. The problem is that it doesn't display the correct filtered data. For example if I select Option2 it will display Option 1, then with Option2 slelected, if i...

Thanks for the help !! I am pretty new in MS Access. For Primary Target 1: you had a great ideea with the cascading combo boxes. But there is a down side to it. I need to complete the filter boxes in order and in case i need to skip one and enter the value in the next one ... it won't be...

I hope you enjoyed your coffee and breakfast. this is what i want to achieve Primary target 1: When I select from filter 1 Option 1, in filter 2 to be available only Option A and Option B ( the ones remaining in the subform ). I don't want Option C to still be there cause if i select it it...

Sure, will post in about 60 min. Thanks

Hello, I have the following: - tblProductList - table with prod1, prod2 and prod3 fields - frmProductList - form, made automatically when I made the subform - frmProductSearch - main form - sfProductList - subform, takes values from the table - cBx1, cBx2 and cBx3 - combo boxes that act as...