List box problem

[Brandon Schultz]

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

SOD_SalesOrderI D is a primary key for the query the list pulls from but
there are duplicate SOD_SalesOrderI D 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

[Bob Quintal]

Re: List box problem

"Brandon Schultz" <allthatisgolde n@hotmail.com> wrote in
news:3f8c58fd$1 _3@newspeer2.td s.net:
[color=blue]
> I have created a list box so that I can navigate through
> records. The AfterUpdate event looks like this;
> Me.RecordsetClo ne.FindFirst "[SOD_SalesOrderI D] = '" &
> Me![lstSalesOrders] & "'"
> Me.Bookmark = Me.RecordsetClo ne.Bookmark
>
> SOD_SalesOrderI D is a primary key for the query the list pulls
> from but there are duplicate SOD_SalesOrderI D 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.
>[/color]
Your line number fields should be on a subform, linked via
SOD_SalesORderI D. Your parent form should only contain the header
info.

Bob Q.