entry form

[June7]

Wait, the RecordSource can't have a WHERE clause restricting to a specific record if you want to be able to move to other records. With that filter restriction, there aren't any other records to move to.



Do one or the other. Reference listbox to filter or use bookmark to move. If you want to use the WHERE then yes, need to requery the form in the AfterUpdate.

[jaykappy]

Phheeewwww....that was it June7....THanks so much .....I removed the WHERE clause in the Forms RecordSource and whamo it worked...
Hey June7 and others that might be following this post...the 2 different methods that we were discussing on the AfterUpdate event of the Listbox work...
BOTH WORK:

On the Forms RecordSource I removed the WHERE CLAUSE
SELECT tbl_V4_Lessons.ID, tbl_V4_Lessons.LessonID,tbl_V4_Lessons.LessonSubje ct,tbl_V4_Lessons.LessonName,tbl_V4_Lessons.Lesson Description FROM tbl_V4_Lessons;

Method 1:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Me![List16] & ""
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

Method 2:
With Me.RecordsetClone
.FindFirst "ID=" & Me.List16 & ""
If .NoMatch = False Then
Me.Bookmark = .Bookmark
MsgBox "Nothing"
End If
End With

THANK YOU FOR YOUR TIME AND PATIENCE JUNE7 VERY MUCH APPRECITED