I have a form with a list box where you can double-click an item and pull up a maintenance form to edit the item selected. Now I've go several of these forms that work, but they all just pass one key field. The sample I have attached uses two key fields from the list box, BUT, the form fails to open with 'form open cancelled' error. My question is, after you take a look at how I've set this up, can two keys fields get passed and if so then what is buggering up my code!?!? Thx for taking a look at it.
stDocName = "frmIssueDetail_editdelete"
key1 = Mid(strIDs, 2, 3)
key2 = Mid(strIDs, 6, 3)
stLinkCriteria = "[issdPrefix]='" & key1 & "'" & " And " & "[issdNumber]='" & key2 & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria