Hi, I have a InfoPath form that has a Training Area ID and Training Area Name
and Training Subject ID and Training Subject name (drop down lists) On my
Data Entry form, when I select a Training Area Name, and then go to select a
Training Subject Name (that list only shows the Subjects for that particular
Area -- which is what I want.

However, I also have another form that is the Search and Edit Form and the
purpose of this is that I have a button to Query by Employee name all of
their training (which it bring back a form for each Training Area and Subject
for that person.  But I want that person to be able to edit the data in those
forms and save it back to the database (which is in Access)  The form is
exactly like the Data Entry Form and I filtered the info just like in the
data entry form.  However when I look at the drop down box for the Subjects,
everything is listed not just for that Training Area.  

Do you have any ideas as to what I can do?  I am desparate.  I think I have
tried everything.

Thanks,

MEG