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

listbox/combo box crashes access 2007

P: 51
My application has a master form as Student, and several child subforms (projects, courses, attendances) attached to a certain student. The master and child are connected by "StudentID".

Taking Courses subform as an example, the form has a listbox field as CourseID, which displays detailed information of a course. The administrator could register a student for a course by selecting a course from the dropdown list.

This application worked fine in 2003. without a problem. But if opened in 2007, while trying to add a new record in the subform, the click of the drop down crashes the application. However, typing in without clicking is OK.

After a whole day search online, I still have no clue at all of how to fix it. Anybody had this problem before? please shed some light.
Oct 29 '08 #1
Share this Question
Share on Google+
2 Replies


P: 93
Hi

Using 2003 and 2007 can cause strange 'unexpected errors'. (at least my experience)

I would create a copy of the db and try to re-construct the subform drop down box using Access 2007 and see if it resolves the issue.


Regards
Emil
Oct 31 '08 #2

mshmyob
Expert 100+
P: 903
Can we see any code for the form.

cheers,

My application has a master form as Student, and several child subforms (projects, courses, attendances) attached to a certain student. The master and child are connected by "StudentID".

Taking Courses subform as an example, the form has a listbox field as CourseID, which displays detailed information of a course. The administrator could register a student for a course by selecting a course from the dropdown list.

This application worked fine in 2003. without a problem. But if opened in 2007, while trying to add a new record in the subform, the click of the drop down crashes the application. However, typing in without clicking is OK.

After a whole day search online, I still have no clue at all of how to fix it. Anybody had this problem before? please shed some light.
Oct 31 '08 #3

Post your reply

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