listbox/combo box crashes access 2007

[anniebai]

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.

[emsik1001]

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

[mshmyob]

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.