I've been trying to do this for hours; can't find a solution.
I've got a continuous form, with a button (cmd1) on each record.
Each record has a unique primary key, RecordID.
cmd1 is clicked to open a form (frm1) based on the RecordID using the following code:
I want frm1 to open, ONLY when a user clicks on cmd1 while it's already in focus ON that specific record.
Any suggestions?
I've got a continuous form, with a button (cmd1) on each record.
Each record has a unique primary key, RecordID.
cmd1 is clicked to open a form (frm1) based on the RecordID using the following code:
Code:
DoCmd.OpenForm "frm1", , , "RecordID = " & Me.RecordID
I want frm1 to open, ONLY when a user clicks on cmd1 while it's already in focus ON that specific record.
Any suggestions?