On Record Change Property?

[racemadnss]

On my form I have a list that needs to be updated whenever the user changes to a new record.

right now im using the OnMouseDown command to Me.Control.Requery, that works fine but I would like the listbox to requery as the user is navigating through the forms.



Thanks

 

[KenHigg]

I would kick it off the record's 'After Update' event. There shouldn't be any reason to requery if the form data didn't change. (right?)

 

[racemadnss]

Well, the data on the page does not get updated but it does change from record to record.

This listbox contain a list of items that pertain to that particular record, and I need it to refresh as the user navigates to the next record. so that the user is looking at data that pertains to current record and not the previous record.

Im really just trying to make a listbox do what a subform does. and update it self automatically.

 

[WayneRyan]

race,

Use the form's OnCurrent event to requery the ListBox.

Wayne

 

[racemadnss]

Awesome thanks,

I dont know why I didnt see that seeing as its the first in the list.

 

[rockman]

Had same question. Thanks for the tip.

Jeff

 

[rockman]

Use of OnCurrent

I can't speak for racemadnss and his listbox issue.

For me, I was trying to change the Caption of the Form (to the patient's name) as the user moved through the database. This could only be performed in VBA and the AfterUpdate event wasn't being triggered since most of the time the record was not being editted.

I suspect racemadnss may also be using VBA code to populate the listbox in a more complicated fashion than just assigning the RowSource to a table/query.

Thanks for the interest,
Jeff