>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,
I guess you use the same data source for grid and combobox. This is wrong solution. Duplicate main table into cursor (Select ... From Accounts Into Cursor tmpAccounts), and use this cursor as RowSource for combobox/listbox and Accounts table as RecordSource for Grid.
Edward Pikman
Independent Consultant