Populate record fields to data sheet from lookup form

[Dunk4Divin]

Hi

I have a form which (via lookups, selected by part number) is looking at all the fields in a selected record in data sheet (this form is for users to view each record without having to scroll along the data sheet). Is there a way to reverse the process and allow the user to enter data into the form and populate the data sheet. The data sheet/workbook contains over 50k records and is not in my control and gathers data from a number of source databases, however, some fields are allowed to be populated manually and I would like to allow users to do this via the "viewing" form.

I'll be grateful for any advice.

Thanks

Duncan