>>When you delete a record out of MyAlias2 are you requerying the dropdown?
>
>I have a dropdown, RowSourceType="6-Fields", RowSource="Myalias1.field1, field2", BoundColumn=2, ControlSource="MyAlias2.Id".
>
>RowSourceType is not a SQL statement. I don't think I need to requery. This problem occurs with integer indexes only. If I change indexes to character field i don't have this problem.
I do remember something about the index being character or integer, but I have not found it yet. If I do I will let you know.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope