List Box - Selection on First Record Repeats thru subsequent

[Larry1216]

I have a form that is based on a table t_XXX.

The form has a list box that is bound to a 2nd table with the following values.

Order Comments
1 Not Excluded
2 Hypertension was not Confirmed
3 End Stage Renal Disease (ESRD)
4 Actual Age is less <46 or > 85 as of 12.31.CY
5 Other Data Error

Upon, selection, the order number is placed a field in table t_XXX.

Unfortunately, when a user makes a selection on a record - the list box for subsequent records repeats that selection. I have a default value for the form and the underlying t_XXX table (1 for both)

Have looked thru the threads but cannot find anything similar. I am not a programmer, just a fairly strong user.

 

[jksmi]

Hi, if you put the order from t_xxx on the form in a locked textbox and put something like...

Private Sub Form_Current()
Me.List1 = Me.txtOrder
End Sub

this updates the list control control as you move from one record to another

Hope this helps, Jamie