Hello All
I am trying to setup a small database program for personal use, as i have done many times before. But for some reason i am having trouble getting this one to work.
I simply have a Data control filling in data bound text or combo boxes with the current selections data. But when i try to move to another selected record by using the
VB Code:
Dim Item As String Item = dbcItemNumber.Text Data1.Recordset.FindFirst "ItemNumber = '" & Item & "'
i get an error...
Runtime Error '3426'
This action was canceled by an associated object.
This is frustraing as this is the same code i've used for other programs and they worked and are still working. Also if i get rid of the variable Item and just have
VB Code:
Data1.Recordset.FindFirst "ItemNumber = 'X001'
It works.
Any ideas anyone?




Reply With Quote