Subform Search

[accessuser]

I need some help on how to create a search base on the subform field. I have
Employe info on the main form, which use EmpID links to the Subform
"FsubCourseInfo". Currently it shows all the courses each employee takes,
but I want to be able to have a search form or search box that would allow
Admin to type in "Year #" so the subform will only give that one particular
year.

Ex). Subform has 2006, 2007, 2008 courses. instead of going through each
one, i want to be able to type "2006" and return all 2006 courses in the
subform for this employee.

There is one very close to my solution is from Allen Browne.
http://allenbrowne.com/ser-62.html

But it mentioned about innerjoint changing the record source of the main
form; it got me very worried to change because my database right now is
working so well after so many days of fixing. I've never worked on the Inner
joint.

Can someone please help me to solve this problem. Thank youu in advance!

 

[Guest]

My suggestion to you is simply make a copy of your main form and subform.
Then your can play around to apply Allen's technique and if ever you do mess
things up simply restore your form with the copy you made.

Allen's technique is a good approach and would be what I would apply. All
your actually doing is filtering the data based on the user's selection. I
suggest you try and implement it.

Daniel