Please can anyone help.

I am trying to setup the following;

I have a table, which has cAccountName, nAccountNumber, lBudgetAccount, cTransferAccount, etc.

I have setup a grid on a form, and my problem is that I would like to have the column for cTransferAccount as either a spinner, list box, or combo box which will show me the current setting but allow me to select anyone of the other accounts from cAccountName.

All my attempts have met with the cursor jumping out of the cell as the selection changes to the row that contains the account that was selected in the cTransferAccount column.

Regards,