hey guys not sure if this is the right area to post this question so my apologies if it should be under somewhere else.
I am trying to right my first vba code for a database. What im trying to do is i want to be able to base my reports off various filters being chosen from different list boxes in this database the options are various departments, subdepartments(really subgroup), and groups. the database itself is an obdc link to a firebird database. my question is how do i get my reports to be based off various results from different forms as i dont want to have to add sub forms to each page rather just have command buttons opening these other forms. So if i am being a bit vague here just not too sure how else to word myself.
I have the combo boxes working fine that save results to a query but dont know how to just have these results saved without actually opening the query. If some1 can just point me in a general direction of what i should b looking at it would be great not so much after code itself just an idea of the way i should be looking at doing this.
Thanks in advance
Jason
I am trying to right my first vba code for a database. What im trying to do is i want to be able to base my reports off various filters being chosen from different list boxes in this database the options are various departments, subdepartments(really subgroup), and groups. the database itself is an obdc link to a firebird database. my question is how do i get my reports to be based off various results from different forms as i dont want to have to add sub forms to each page rather just have command buttons opening these other forms. So if i am being a bit vague here just not too sure how else to word myself.
I have the combo boxes working fine that save results to a query but dont know how to just have these results saved without actually opening the query. If some1 can just point me in a general direction of what i should b looking at it would be great not so much after code itself just an idea of the way i should be looking at doing this.
Thanks in advance
Jason