Combo Boxes within a Datasheet Form

[ckrogers]

Hi!
I've got a datasheet form called "Unassigned Jobs" with only one field
enabled ... a combo box for the field "Job No". The combo box has a query
for the "Row Source" ... with a criteria of "[Forms]![Unassigned
Jobs]![MoldID]".

The idea of the datasheet form is to display all requests that haven't had a
"Job No" assigned yet. There's two different possibilities:
1. A job may have already been set up for that specific "MoldID", so the
combo box should display all available jobs for that mold and the user can
choose the appropriate "Job No".
2. If a job has not been set up yet, the user will go set up the new job.
In that case, the combo box will have to be re-queried for all available jobs
so the user can choose the appropriate "Job No" ... including the new job.

My combo box for the entire datasheet is only showing jobs available for the
"MoldID" in the very first line. I've added "Me!MoldID.Requery" to the "On
Click" event on the combo box thinking that would help with both of my
scenarios ... but that's not working.

If I click on a specific line of the datasheet, and displays the combo box,
I get an invalid list of jobs. When I look at and run the query the combo
box is based on ... I get the correct list of valid jobs. If I go back to
the datasheet form and re-display, my combo box then displays the correct
list.

Help, please!
Cindy