once you post a question in any newsgroup, best practice is to wait at least
a day after the last post to the thread, before re-posting the question to
the same, or another, newsgroup.

in this case, my answer wouldn't really have changed, since i gave both the
macro action and the VBA code that you need to requery the combo box.
whether the value of MoldID changes between records, or by user data entry,
at some point you still need to requery the combo box.

my first thought is that there is a problem with the query itself, but you
said it returns the correct records when you open it independent of the
form, so that seems unlikely. did you set up the VBA code or macro to
requery the combo box OnCurrent, and AfterUpdate (as specified in my
previous post)? if you did, and it still doesn't work, then my only other
suggestion is that you
1) double-check the combo box's RowSource to make sure you have the correct
query name in it, and
2) check the combo box's RowSourceType property to make sure it's set to
Table/Query.

hth