List Box

[shaz123]

Hi All,

I have a list box which finds a record dpeending on the field selected. The field name within the listbox is based on the work order number, Onec it is selected the individual order name should appear when a works order number is selected.

However if there is the same works order number then, a diff order line should show for each one, however when selecting each matching work order number the same order line shows, How do i get the right order to show, will i need to put sum coding in.

For Instance
Works Order Number Line Number Cylinder barcode
122556 0001 512520
122556 0002 158863

In the list box i have got both worksorder number but when clicking on each only one fo the orders show

Hope ive made sense

 

[Pampers]

I would think that a WorkOderNo should be a unique number?


Pampers
Keeping it simple can be complicated

 

[shaz123]

Works order number cannot be a unique number in this case, a bit hard to explain, do u know anyting a building list indexes.

 

[Pampers]

Maybe have a look at this article how to use the multi-select property of a list box to filter multiple records...

http://support.microsoft.com/kb/135546

Pampers
Keeping it simple can be complicated