> i'm using a bound form that contains combo boxes that have values from
> the table that is bound to the form.
[quoted text clipped - 6 lines]
> NOTE: please try to answer without lecturing about what microsoft or
> somebody thinks about filling combo boxes.
A ComboBox is either used to navigate records (what you want) OR it is
bound. You cannot use the same ComboBox for both. The ComboBox wizard will
build an unbound control for navigating.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
mcnews - 27 Sep 2007 20:00 GMT
> > i'm using a bound form that contains combo boxes that have values from
> > the table that is bound to the form.
[quoted text clipped - 15 lines]
> Email (as appropriate) to...
> RBrandt at Hunter dot com
danged if you ain't correct!
had to fix that real quick.
Me.RecordsetClone.Findfirst "[ID] = " & Me![ComboOrListboxName]
Me.Bookmark = Me.RecordSetClone.Bookmark
Klatuu - 28 Sep 2007 15:01 GMT
Although unlikely, you should always include code that will not try to
navigate to the record if it was not found:
With Me.RecordsetClone
.Findfirst "[ID] = " & Me![ComboOrListboxName]
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With

Signature
Dave Hargis, Microsoft Access MVP
> Me.RecordsetClone.Findfirst "[ID] = " & Me![ComboOrListboxName]
> Me.Bookmark = Me.RecordSetClone.Bookmark