Solved Problem by Recreating Form from scratch based on the same table & with a new Combo Box. There must have been some corruption taking place. Now OK
Thanks for your responses
ERROR ON COMBO BOX
Generated code by Combo box wizard
Sub Combo22_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo22]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
With Row source
SELECT...
Using a combi box in a form on Access 97 to lookup records , when I click an item from the drop down box, Error 3021 (No current record) is displayed . Obviously the record does exist. I've removed any filters from the form & the subform and also deleted the combi box & recreated it. Coding...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.