Open a form from a datasheet form to edit

[Dan]

I have a form that is a datasheet view of my product table. I like the
datasheet view so the user can scroll through the records and pick the
record that he/she wants to edit. For simplicity, lets assume the for is
"product.form" and it has the fields "partno" and "description". Once the
user selects (highlights) a record I want them to click an "Edit" button to
bring up "EditForm" with partno and description of the record they selected.
Then they can edit the field and save the changes.

Assuming partno is ABC001 how do I code the Edit button to open the
"EditForm" with ABC001 partno?

Thanks
Dan

 

[Rick Brandt]

I have a form that is a datasheet view of my product table. I like the
datasheet view so the user can scroll through the records and pick the
record that he/she wants to edit. For simplicity, lets assume the for is
"product.form" and it has the fields "partno" and "description". Once the
user selects (highlights) a record I want them to click an "Edit" button to
bring up "EditForm" with partno and description of the record they selected.
Then they can edit the field and save the changes.

Assuming partno is ABC001 how do I code the Edit button to open the
"EditForm" with ABC001 partno?

Just make sure the toolbox wizard is enabled when you drop the command
button onto the form. One of the options in the command button wizard does
exactly this.