Strange problem/question

[Joe Holzhauer]

I have a listbox that lists a series of items that is requeried after a
combobox is changed (employee evaluations--the list of evaluation items is
requeried when you select a different employee). When the user hits 'S' or
'U', the item is marked either satisfactory or unsatisfactory. That all
works fine.

The problem is: Let's say I'm on the 15th item for one employee, then I
select a different employee. After I requery the list and select item 0
(lstBox.Selected(0)=True), when I hit 'S', the 15th item is marked
satisfactory, not the 1st.

Is there a step I'm missing? I tried adding the line Me.Dirty=False to save
changes, but that didn't work.

Any ideas would be greatly appreciated!!

Thanks,
Joe

 

[Rob Oldfield]

Drop a breakpoint into the code that runs when you hit S. Somewhere in
there you have a variable that is retaining '15' (or, more probably, '14' as
the list is zero based). Find that and you should be able to reset it
whenever you move to a different employee.