>>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.

Is your BoundTo property set to True?