I have two forms, each containing a combo box whose values come from tables other than the one the form links to. I find that if data entry mode is No, both combo boxes populate correctly. If I set Data Entry to Yes on both forms, the combo box on one does not populate, but the other is still OK. I can find no difference between the forms to explain this. I'm using Access 2007.
Update: it seems to be a bug that arises when you hide a column on a datasheet form. I have four columns. Hiding one does no harm, but hiding another causes the combo box to fail to populate, whether or not in Data Entry mode. Unhiding a column does not fix the problem - the form is now corrupt and must be deleted and re-created.
Update2: the corruption can be undone by switching to single form view then back to Datasheet view.