By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

Access form won't reset unless closed and reopened

P: 2
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.
Feb 1 '08 #1
Share this Question
Share on Google+
2 Replies


MindBender77
100+
P: 234
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.
Expand|Select|Wrap|Line Numbers
  1. me.refresh
  2.  
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
Feb 1 '08 #2

P: 2
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.
Expand|Select|Wrap|Line Numbers
  1. me.refresh
  2.  
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
Feb 1 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.