Can someone explain to me as I seem to be the missing link. I open a form which is linked to 1 table. The primary field is named Spin. My form opens blank which suits me. However I thought if I entered the spin vlaue for an existing record the rest of the fileds would automatically fill out on the form. But it does not! Can anyone point out to me where I am going wrong?