Updating a query

[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?

 

[Ian Mac]

You would use code.

On the 'Employee Details' form add a button or use the Update button if you have one.

Add the line

Forms![YourFormNameHere].Requery

That should refresh the data in the other form.

Also, please delete your duplicate post and continue with this one, thanks.