Updating a query, when still in the form

[Nats]

I have 2 fields in a form called 'Employee No's' which use a combo box (this information for these comes from a query). However, I have another form called 'Employee Details' (this form comes from the same table as the query is taken from).

The 'Employee No's' form opens by a command button in the 'Employee Details' Form. However, what I need to be able to do is for the query (used for the combo box) to update with information I have just put in the 'Employee Details' form while I have not yet closed the 'Employee Details' Form.

Would I use an SQL statement for this? If so what would I put?

 

[ajetrumpet]

How about this statement for the actual query that runs the combo box...

SELECT [fields]
FROM [table]
WHERE [desired field 1] = Forms![Employee Details]![related control name] AND [desired field 2] = etc, etc, etc;

maybe "onclick" for the command button, a RUNQUERY command to update the box??