Subform Field - blank on SOME records

[Guest]

Help! I have a two fields on a subform. Field 1 is entered via a drop-down
combo box and then Field2 is also entered via another combo box (but it only
lists the subthemes relevant to the first field). When you change the first
box different options then appear in the Field2 dropdown box. This works all
very well, except for one of my records where Field2 keeps reverting back to
a blank on the screen. However the info is still in my table and still
prints on reports. Any ideas/help

 

[Guest]

When you change the value in the Parent cbo, it changes the rowsource of the
child cbo. IF the value previously selected for the child is no longer
within the dataset returned by the new rowsource, then Access simply shows a
blank for that instance of the child cbo. (If you look in the actual table,
you will see that a value is retained.) So, until the child rowsource is a
dataset that contains the saved value, you will see a blank.

The moral of the story is don't try to use dependent combo boxes in a subform.