yaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaay!!!!!!!!!!

i did it!!!

incase anyones wondering how i did it....
i changed the index value of Last Name to Yes(allow duplicates) and then used dtaData.recordset.index = "Last Name" and voila!!