I have a form with a bound combo box listing names, [myname] and a multiselect list box that lists all available forms in a database [myselections]. I am really struggling with code that will enable the user to hit a command button that will then open the selected forms to show the data for the selected individual. I have found things related to selecting items in tables etc but not related to opening forms to specific entrys and I am just not experienced enough with SQL to get this working. Can anyone help or direct me to a good example?
opening forms
- Thread starter wakiwi
- Start date
Treason
#@$%#!
- Local time
- Today, 16:18
- Joined
- Mar 12, 2002
- Messages
- 340
If your main form will always be open, and will serve as an Homepage of some sort, then create a query using the tables you want, then find the myname field in the query and under criteria put [Forms]![MyFormName]![myname]. This way the query will only show names that match the name on your form. Remember this will only work if the main form is open when you run the query.
Based your secondary form on that new query.
I tried to explain in the simpliest terms
Cheers
Based your secondary form on that new query.
I tried to explain in the simpliest terms
Cheers
