Requery on record change

[Dustman]

I've got a listbox with no control source. The row source is set with a procedure called RefreshFlags. I need to call RefreshFlags everytime the user changes to a different record, whether by loading the form with another form, or clicking the record selectors at the bottom.

I can use the form load or activate methods to handle refreshing on opening from another form. How do I call the procedure when they click on the record selectors? Is adding my own record selectors the only solution or am I missing a form method for this? -Dustin
Rom 8:28

 

[BoxHead]

Dustin,

Run your listbox.requery on the OnCurrent event.

OnCurrent should fire with each record chamge no matter how you get there.


HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[Dustman]

Thats what I needed.. Thanks! I keep switching from Java, VB, and Oracle... sometimes I just can't seem to find things .

Thanks again! -Dustin
Rom 8:28