I try to link two combo box using a common key in two related tables.
I have set both the combo box record source type as "fields", with record source as fieldnames that I wish to display on the combo box.

However, when I tried to refresh the related combo box after selected the parant combo box item, it gives me "Record out of range" error message.

This error message does not appear every time. Kindly advise & Thank you.