i am in a real pickle. ive got my main form named frmSupplier and it can populate the table it links to called tblSupplier, the subform however does not populate anything in tbl Person.
Ive messed around with the code for quite long now.
What i want it to do is to firstly get the autonumber called PersonID in the subform to work, (there is also a PersonID in the main form). once that works i need the PersonID from subform to copy or send that same number to the field in the main form, the subform then uses the number in the main form to populate itself with the data.
Its a bit challanging if anyone could help or at least point me in a general direction it would be highly appreciated.
Regards,
Bilal
Ive messed around with the code for quite long now.
What i want it to do is to firstly get the autonumber called PersonID in the subform to work, (there is also a PersonID in the main form). once that works i need the PersonID from subform to copy or send that same number to the field in the main form, the subform then uses the number in the main form to populate itself with the data.
Its a bit challanging if anyone could help or at least point me in a general direction it would be highly appreciated.
Regards,
Bilal
