Access 2010, record selection not firing on click

[drhowells]

Hello,

I have a Form (continuous form) which comprises a PK, a number of fields and an Image serving as a button [that has an On Click event]. The desired functionality is for the user to click the button (code below) which opens a form populated with editable data for that specific record.



Whichever button is clicked, the Job_Code is 18. If I click directly into the record for 19, then the Job_Code is correctly 19; the issue seems to be that clicking the image does not select the record... can this be resolved?



Event Code

Private Sub BTN_MAIN_EDIT_JOB_Click()
    
DoCmd.OpenForm "MODALFORM_ED_Job", acNormal, , , , acWindowNormal, [Job_Code]

End Sub

Advice much appreciated!

[pbaldy]

I suspect you want this technique:

http://www.baldyweb.com/wherecondition.htm

It looks like you're putting the value in OpenArgs, which would require code in the form being opened.