How do Form properties affect combo boxes?

[Cathii]

I have a combo box on two individual forms in Access2003. One works perfectly, the other doesn't work at all. The issue is that the combo box that doesn't work won't allow you to select via the mouse nor the keyboard ANY value. The working combo box allows both.

The row source for each combo box is:

SELECT mdl_course_competencies.competency, mdl_course_competencies.competency_id FROM mdl_course_competencies ORDER BY mdl_course_competencies.competency;

All properties for the combo box are the same on each form (except for the name). The form properties only vary with one being a bound form and the other being unbound.

My question is, why would it work in one form (the unbound form) and not the form that is bound? Is it due to the form properties or am I missing something totally obvious?

Thanks
Cathii

 

[Moniker]

What is the bound form bound to? That's going to lead you to the solution...

 

[Cathii]

What is the bound form bound to? That's going to lead you to the solution...

It is bound to a different table (mdl_course) in the current DB. All the tables are linked to a MySQL server via an ODBC driver. The actual data source is the data set for a website created with Moodle ( an online learning system - WinServer2003-Apache-PHP-MySQL). I have got to the desperate point of locking the DB for sole access, rebooting the server and eating lots of chocolate!!

On the bound form I have several unbound text boxes drawing data from various tables in response to selections in the main part of the form, all working as expected, an unbound list box, also working properly, and 2 subforms. The combo box is the only thing refusing to cooperate despite drawing data from only one table and requiring no extra input.

I have been staring at this screen now for hours because of this one little but essential thing which happens to be the last stage before I distribute it to the training section's course facilitators. Getting a little frustrate and considering playing WoW instead of working... for the sake of my own sanity!!!!!

Cathii