Filtering

[chris11590]

i created a subform of branches which breaks down to groupsector. i would like to just select branches by Ids groups. for example, branch id #1 I dont know want to see branchid #2 or branchid #3.

the form is based of table. i have tried to base it off a query but then too many queries are necessary and also i can t edit or make entries into the form, which i believe is so bc the form is based off a query.

is there a sql statement i can use, or is there the "filter" or order by" properties i can use" ?????????????

please help. have tried everything. one step from completting form. sample attached.

 

[CyberLynx]

Well Chris, you can do it either way. You can use a Filter or the Filter Property of the Sub-Form or you can use a SELECT Query either made through the Access Query Wizard or through code.

I had modified your previously posted Sample DB to show how you can accomplish either way (Filter or Query) through code. You should look in the Code modules for both the Main Form and the Sub-Form. The code is well documented.

When you have the Main Form open.....read the Control Tips that pop up in the Sub-Form. Play with the buttons within the Sub-Form and those that have been added in the Main Form. You will quickly see how things were done.

hope this helps.

.

 

[chris11590]

Thank you!!!!!!!!!!!!I am so jealous. I wish I had the ability to do it that quickly. I am been trying to teach myself but has not come easy. thank goodness for the forum and all the help i receive.

the only problem i face, is i can have the form showing the filter and sorting buttons.. i m looking for the module but can find it.

Thank you again!!!!!!!!!!!!!!!!

 

[CyberLynx]

the only problem i face, is i can have the form showing the filter and sorting buttons.. i m looking for the module but can find it.

I don't quite understand what you mean by this. Do you mean you can not find the the Code modules for the two Forms?

If this is the case then you will find the Code within the VBA IDE (Visual Basic for Applications editor). You can access the code editor by selecting the Form name from within the Database Window then in the MS-Access menu bar select View then Code.

The Database Window is the Window that displays the list of all your Tables, Queries, Forms, Reports, Pages, Macros, and Database Modules (database code modules are not Form code modules).

.