Hi All, me again

I now have my form set up with a main form and 2 subforms. 1 showing roles and the other showing courses based on the role.

What I can't figure out is how to add a role in 1 subform and have the second subform requery and show the courses.

All data is normalised into correct tables.

The only way I can get it to work is to move off the record and then back again, so guess the underlying tables and queries are OK.

Andy

Andy,
In the after update event of the role field put:
Me.refresh
Forms!mainform.Secondsubform.form.requery

Should work.

Kevin

dartcoach

Andy,

You should also put:

Forms!Mainform.SecondSubform.form.requery

In the on current for the first subform. This insures that when you click on a role that's already there, the second subform will refresh with the correct data.

Kevin

dartcoach

Hi Kevin,

I am also having a problem requerying a subform.

I patterned the requery after the code you suggested, but I am

getting an error message.

If you have time to look at my problem, I would greatly appreciate it..

thx, Sandra