Unable to make selection from Combo Box

L

LGordon

Hello:
Recently I have converted a Access 97 database to an
Access 2000 database. I copied a version onto a CD, hence
making it read only. The problem I have been having is;
whenever I try to input data in one of the data entry form
I keep running in the error "No Current Record." This
database works for fine in the 97 version on CD, and the
2000 version on my local drive. My only problem is on the
2000 version on CD.
I must say on the form there are 2 unbound ComboBox
controls, whenever the form is open on 97 version, the
boxes are blank. Whenever the form loads on 2000 CD
version, one box contains data, and the other does not, it
is at this point when a selection is made from the drop
down list that the error occurs.
Here is the code for the update event for that ComboBox:

"Private Sub cboLCNFind_AfterUpdate()
Dim rst As Recordset
Dim strCriteria As String

Set rst = Me.RecordsetClone
strCriteria = "FMEA.LCN = '" & Me!cboLCNFind & "'"
rst.FindFirst strCriteria
Me.Bookmark = rst.Bookmark
rst.Close

Me![FM].SetFocus
End Sub"

Thank You,
L Gordon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top