Access form won't reset unless closed and reopened

[LJBlong]

Access 2003 Windows XP

All information comes from Table1 except for Teacher and Course which comes from Table2. Information selected in the drop down boxes from Table2 becomes a part of Table1. Table2 lists the teachers and the courses they teach. Teachers have multiple courses.

A problem occurs if the wrong teacher name is selected from the drop down menu. When a new name is selected the course selection doesn’t change and contains the list for the 1st name selected. The only way to refresh it is by closing the form and reopening it. (Not a problem for me, but for some teachers it is.)

I'll include images if someone will tell me how to do this.

[MindBender77]

Access 2003 Windows XP

All information comes from Table1 except for Teacher and Course which comes from Table2. Information selected in the drop down boxes from Table2 becomes a part of Table1. Table2 lists the teachers and the courses they teach. Teachers have multiple courses.

A problem occurs if the wrong teacher name is selected from the drop down menu. When a new name is selected the course selection doesn’t change and contains the list for the 1st name selected. The only way to refresh it is by closing the form and reopening it. (Not a problem for me, but for some teachers it is.)

I'll include images if someone will tell me how to do this.

There are a few things you could try. The first would be to add a simple code to the OnChange event of the last combobox or drop down menu.

me.refresh
 

This should refresh the data instead of having to close down the db.

The second option would be to add error handling that would prevent the wrong teachers name from being selected.

JS

[LJBlong]

There are a few things you could try. The first would be to add a simple code to the OnChange event of the last combobox or drop down menu.

me.refresh
 

This should refresh the data instead of having to close down the db.

The second option would be to add error handling that would prevent the wrong teachers name from being selected.

JS

I think that's going to fix the problem. I had been using requiry. I'm not sure when to use refresh or requiry when writing code. Thanks