I have a form that is used to edit and enter records. I have a datasheet which contains part no's. The Part No. is the primary key for the the datasheet\table. I want to click on a part no. and have that record pulled up in the form for editting. I've attached a screenshot of the macro I've currently been working on. I've gotten as far as being able to pull up the form but it won't pull the record I click on - it just pulls the first record in the table. So obviously I'm doing something wrong.
Any help is appreciated. Thanks.