Navigation Buttons-How to Requery Combo Box?

[isorders]

I have a form that has a field called Node.
I then have a another form that has a ToNode and FrNode Field that combines to make a ToNode-FrNode=LineName.

On the Node Form I want to show all Lines associated with the selected Node.

So if a Node (C45) is found in the LineNames C45-B34 and G42-C45 then I want those items to appear as Lines associated with the C45 Node.

As I flip through the Node records the associated lines should change.

I have tried list boxes and combo boxes and sub forms, but I can't seem to get them to update if the person uses Navigation buttons. I also have a Node Select Drop down and I can requery the LineName list box after update, but I don't know how to requery the records with a Navigation button. There will be thousands of Nodes so the Navigation buttons really speed up finding things.
Thanks

 

[psemianonymous]

The Form_Current() event runs every time a record is "loaded" - this means whenever you open the form, or when you move to the next/previous record. I'd recommend calling your update code from this event, thus guaranteeing that your calculated field will be refreshed when you view a new record.

 

[isorders]

That was what I was looking for. It works great.