Hi
I am creating an application to log calls and require a user to be able to retrieve any call by entering the unique reference number.
I have connected my application to an Access DB via a data control.
To search for the reference number entered by a user I have used the code below that I have seen work on another persons application but in my application I get the following error: "Run-Time error 3251 Operation is not supported for this type of object"
Private Sub cmdRetrieveCall_Click()
FindRefNo = InputBox("Please enter the reference number you wish to find", "Find Reference Number"
frmCallInfo.Data2.Recordset.Index = "PrimaryKey"
frmCallInfo.Data2.Recordset.Seek "=", FindRefNo
End Sub
I am creating an application to log calls and require a user to be able to retrieve any call by entering the unique reference number.
I have connected my application to an Access DB via a data control.
To search for the reference number entered by a user I have used the code below that I have seen work on another persons application but in my application I get the following error: "Run-Time error 3251 Operation is not supported for this type of object"
Private Sub cmdRetrieveCall_Click()
FindRefNo = InputBox("Please enter the reference number you wish to find", "Find Reference Number"
frmCallInfo.Data2.Recordset.Index = "PrimaryKey"
frmCallInfo.Data2.Recordset.Seek "=", FindRefNo
End Sub