- Joined
- Apr 13, 2006
- Messages
- 1
- Reaction score
- 0
hi,
i have a form with an unbound list box. the list box is more like a display window which shows info about previously entered data on other forms. based on a control used in the form, the list box is updated when there is a change made to the control. but if there is no change, then the list box shows old data, that is, when i am going from one record to another on the same form, without making any changes, i only see the display on the list box as that of the first record. i am not sure how to refresh/requery the form so that if i go from one record to another in the same form, i should be see display on the list box pertaining to the record which is on focus. someone pls let me know the procedure/code to use.
thanks
sm
i have a form with an unbound list box. the list box is more like a display window which shows info about previously entered data on other forms. based on a control used in the form, the list box is updated when there is a change made to the control. but if there is no change, then the list box shows old data, that is, when i am going from one record to another on the same form, without making any changes, i only see the display on the list box as that of the first record. i am not sure how to refresh/requery the form so that if i go from one record to another in the same form, i should be see display on the list box pertaining to the record which is on focus. someone pls let me know the procedure/code to use.
thanks
sm