Hi Chuck,
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?
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).
I'm unclear what you mean by 'changes the data'. Is the wrong AuthType being stored in Auth?
Barbara
>I am FREAKED OUT! How can the ControlSource of the Combo1 be something else (auth.authtype) and still call the desired listing (authtype.authtype)? At first, it looks like ok, but it still changes the data... somebody please help!
>
>Chuck
>