thanks for the reply,
but it didnt work, its either i dont really understand or the code doesnt work
say i want to load the main form to the last record of the productid
I have tried to set the subform to load to the last record, but when i open the main form, it only goto the last record for...