I have a worksheet which has 2 cells unprotected to accept a date and a
clientID respectively. I also have a commandbutton with a macro behind it to
take the two cell values and pass them to a SQL query which returns results
to another section of the worksheet.

When using the sheet there is a tendency to input the date, tab to the
client ID, key in the ID and then click on the command button. Unfortunately,
until the client ID field has lost the focus, the command button has no
effect. If the user presses <enter or tabs out of the clientID cell then the
button works fine.

I'm sure this must be easy to fix. I would really appreciate some help.

Thanks.