Subform Search

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!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200612/1

.

Relevant Pages

  • Re: Subform Delete Record and Filter By Form
    ... relation between your Employee table and the courses the employee takes. ... then putting a command button in your subform is fine if you ... If Filter By Form does what you need, then by all means use it. ...
    (microsoft.public.access.formscoding)
  • Re: New to Access db
    ... The Foreign Key fields in the Subform which arentt linked to the main form ... Add EmpID and Employee to the query. ... AttEventID - Primary key Auto Number ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Want all fields to show when Item selected
    ... audited to be sure the employee has filled them out correctly; ... Is it on tblAudits? ... since each audit can have many details. ... selection populates a combo box on the subform. ...
    (microsoft.public.access.forms)
  • Re: Create complex data entry form
    ... Within the Employees subform is a second ... EventTopicID that ties the employee to a specific event and a specific topic ... TblEvent so you can select the event. ... Use a form/subform-subform to record event-topic attendance. ...
    (microsoft.public.access.forms)
  • Re: Create complex data entry form
    ... There is no employee subform. ... it's important to track topic attendance individually. ... TblEvent so you can select the event. ...
    (microsoft.public.access.forms)