Chuck,
Please do send it and I'll take a look. Just click on the envelope by my name for my email. Be sure you include your name in the message so it doesn't get trashed.

Barbara

>I will try again in English.
>
>First of all, I have a grid and the grid is for showing data from the AUTH table. Now, when clicking on the Text1, the Text1 becomes a combobox, with a drop down list, SQLing from the AUTHTYPE.authtype. When choosing from the combobox listing (AUTHTYPE.authtype), the data is then replaced in the Text1 (AUTH.authtype). I have that all working fine.
>
>The problem is when looking (viewing) at the grid, we see the regular data from the AUTH table. When clicking the Text1, the viewing data (Text1) changes (overlaps) with whatever the record pointer is on the AUTHTYPE.authtype. This makes it looks like the something isn't right.
>
>Not only that, if I click on another record Text1 (same field, different record), the combobox shows whatever the record pointer was at from the pervious record, making it looks like it changed, but techincally not (it just overlapping).
>
>If you like me to zip up the project and email this to you, it would be easier to see what I am talking about. The zip would be about 48KB.
>
>To Barbara, yes, I have both (Combo1 and Text1) ControlSource set to the same table, via AUTH.authtype, still not showing as should.
>
>Chuck
>
>YES.
>>Combos are a link between two tables. The 'list' of data you see on the combo is from one table, but the data you pick is stored to another. In your case, you wish to pick AuthType from the AuthType table and store the value in your Auth table, right?
>
>YES, understood.
>>So, the Combo's RowSource describes the data you see when the combo is dropped down (all of the AuthType table). Its ControlSource is the field the data is stored to (Auth.AuthType).
>
>When clicking on the Text1, the existing data from the Auth table is no longer showing, but showing from the Combo1 (AuthType table)
>>I'm unclear what you mean by 'changes the data'. Is the wrong AuthType being stored in Auth?