List Box Selected? Or Not??

[taber13]

I am tring to find a way to select a particular row or index of a select box based on a seperate text box value.

I have a select box on a form which when a item is selected it populates two different HIDDEN text boxes with certian values. when use the navigate buttons to toggle through the records the select box is not updated according to weather or not the particular value has been selected or not.

Question :
How do I update a selectbox row and make it selected or not based on a value in another text box.

 

[taber13]

Never Mind I figured It Out

Added a Event to On Current. Sorry For The Fuss!!
If anyone needs any more detail on what this was about E-mail me.

Private Sub Form_Current()
If Me!Accessories = "Null" Then Me!accessorieslist.Selected(0) = False Else: Me!accessorieslist.Selected(0) = True
If Me!accessories2 = "Null" Then Me!accessorieslist.Selected(1) = False Else: Me!accessorieslist.Selected(1) = True
If Me!accessories3 = "Null" Then Me!accessorieslist.Selected(2) = False Else: Me!accessorieslist.Selected(2) = True
If Me!accessories4 = "Null" Then Me!accessorieslist.Selected(3) = False Else: Me!accessorieslist.Selected(3) = True
If Me!accessories5 = "Null" Then Me!accessorieslist.Selected(4) = False Else: Me!accessorieslist.Selected(4) = True
If Me!accessories6 = "Null" Then Me!accessorieslist.Selected(5) = False Else: Me!accessorieslist.Selected(5) = True
If Me!accessories7 = "Null" Then Me!accessorieslist.Selected(6) = False Else: Me!accessorieslist.Selected(6) = True
If Me!accessories8 = "Null" Then Me!accessorieslist.Selected(7) = False Else: Me!accessorieslist.Selected(7) = True
If Me!accessories9 = "Null" Then Me!accessorieslist.Selected(8) = False Else: Me!accessorieslist.Selected(8) = True
If Me!accessories10 = "Null" Then Me!accessorieslist.Selected(9) = False Else: Me!accessorieslist.Selected(9) = True

End Sub