Navigating with bookmarks (1 Viewer)

[JRRyan]

Hi there, I'm new to the forum but it seems as if there's a lot of help available here.

I'm trying to use a combobox to navigate the records in an uneditable form based on a query. I'm using the following code (many of you may recognise it):

Private Sub Text33_AfterUpdate()
On Error GoTo Err_Text33_AfterUpdate

DoCmd.SetWarnings False
Me.RecordsetClone.Findfirst "[ID] = " & Me![Text33]
Me.Bookmark = Me.RecordsetClone.Bookmark
DoCmd.SetWarnings True

Exit_Text33_AfterUpdate:
Exit Sub

Err_Text33_AfterUpdate:
MsgBox Err.Description
Resume Exit_Text33_AfterUpdate

End Sub

I'm not getting any response from this, and when I used a standard table instead of a query the field would change its value before moving to the cloned record.
Any help?

 

[Rich]

Use the combo box Wizard, it'll create the code for you, and please don't double post

 

[JRRyan]

OK I've found a system with the wizards available and the como box wizard does not build this for me. It simply build the combo box, no option for record operations.

 

[Ukraine82]

Are you talking cascading combo box? Whatever you select from a combo box you want that record to be displayed?

Michael

 

[Rich]

OK I've found a system with the wizards available and the como box wizard does not build this for me. It simply build the combo box, no option for record operations.

Select, find a record on my form, from the list of available options