I have created a list box so that I can navigate through records. The
AfterUpdate event looks like this;
Me.RecordsetClone.FindFirst "[SOD_SalesOrderID] = '" & Me![lstSalesOrders] &
"'"
Me.Bookmark = Me.RecordsetClone.Bookmark

SOD_SalesOrderID is a primary key for the query the list pulls from but
there are duplicate SOD_SalesOrderID records for multiple line numbers
(SOD_SOLineNbr). So, although the list populates with the the records
whenever you select Sales Order line number 2, 3, 4 etc. it does not pull up
the records data in the corresponding text boxes I have on the form. Only
the first line number pulls in ok. I end up having to use the navigation
buttons on the bottom; Which I'd like to eliminate.

Any help would appreciative.

Brandon Schultz

Hi,


So, instead of FindFirst, use FindNext:


With Me.RecordSource
Me.Bookmark=.Bookmark
.FindNext strCriteria
If .NoMatch Then
.FindFirst strCriteria
End If
If .NoMatch Then
MsgBox "Sorry, no Match"
Else
Me.Bookmark=.Bookmark
End If
End With



Hoping it may help,
Vanderghast, Access MVP





"Brandon Schultz" <(E-Mail Removed)> wrote in message
news:3f8c5933$(E-Mail Removed)...
> I have created a list box so that I can navigate through records. The
> AfterUpdate event looks like this;
> Me.RecordsetClone.FindFirst "[SOD_SalesOrderID] = '" & Me![lstSalesOrders]
&
> "'"
> Me.Bookmark = Me.RecordsetClone.Bookmark
>
> SOD_SalesOrderID is a primary key for the query the list pulls from but
> there are duplicate SOD_SalesOrderID records for multiple line numbers
> (SOD_SOLineNbr). So, although the list populates with the the records
> whenever you select Sales Order line number 2, 3, 4 etc. it does not pull
up
> the records data in the corresponding text boxes I have on the form. Only
> the first line number pulls in ok. I end up having to use the navigation
> buttons on the bottom; Which I'd like to eliminate.
>
> Any help would appreciative.
>
> Brandon Schultz
>
>