Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
David92595
Starting Member
8 Posts |
 Posted - 2012-08-21 : 21:02:15
|
| Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end.I need to find a way of opening up a main form and one of several possible sub forms depending on a criteria. A more literal way of putting it is I'm trying to, based on an on click open up a form and also open up a sub form within that form based on state. We have a main table and several other tables that contain information based on state. The main form will be based on the main table and holds our ID# and State. What I need to do is be able to open a states table in the sub form based on what state is listed in our main table.Is there a query I can create that will do this using Joins between all the different state tables?Any Ideas?As always, any help is greatly appreciated. David92595 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-21 : 21:16:25
|
| sounds like an access front end issue. you may be better of posting this in MS Access forum------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
David92595
Starting Member
8 Posts |
Posted - 2012-08-24 : 13:37:26
|
| Thank you, I will in an Access forum |
|
|
|
|
|
|
How To Open A Subform Based On A Criteria,