By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,205 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

List box problem

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Brandon Schultz" <al*************@hotmail.com> wrote in
news:3f**********@newspeer2.tds.net:
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.

Your line number fields should be on a subform, linked via
SOD_SalesORderID. Your parent form should only contain the header
info.

Bob Q.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.