Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searching an access db connected by a data control, on the Primary Key

Status
Not open for further replies.

NickBlake

Programmer
Nov 28, 2003
10
GB
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top