If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
search feature with subforms
On one form which I call it the "search form". The combo
box(unbound) contains the data for the types of Training from a table (using select statements). On the main form, it is getting data from a table that shows the name of people and department. On the subform (continuous form), it shows the different types of training these people have which is linked to the main form. What I am trying to do is when I select a type of Training (ie. orientation) from the combo box on the Search form, I want the main form to only show the people who have taken the orientation. It is comparing the training from the combo box on the search form and the training field in the subform. |
#2
|
|||
|
|||
See:
Filter a Form on a Field in a Subform at: http://members.iinet.net.au/~allenbrowne/ser-28.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "ashley" wrote in message ... On one form which I call it the "search form". The combo box(unbound) contains the data for the types of Training from a table (using select statements). On the main form, it is getting data from a table that shows the name of people and department. On the subform (continuous form), it shows the different types of training these people have which is linked to the main form. What I am trying to do is when I select a type of Training (ie. orientation) from the combo box on the Search form, I want the main form to only show the people who have taken the orientation. It is comparing the training from the combo box on the search form and the training field in the subform. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search Engine | Scott Matheny | New Users | 1 | July 28th, 2004 08:39 PM |
Search Function | Matthew DeAngelis | General Discussion | 0 | July 21st, 2004 06:05 PM |
SQL Search Query | Jamie Bray | Running & Setting Up Queries | 1 | June 10th, 2004 12:36 PM |
How do I make a search form?? | Scott | Using Forms | 1 | June 1st, 2004 08:03 AM |