Update list box

[soulice]

I have a form (of a single record) with a list box showing related records based no a relationship. The first records list box is great, shows what I want. When you navigate to the next record is still shows the data from the first record.

My query for the list box ends with
WHERE (((Table.RefID)=[Form]![ID]))

I am obviously missing something simple...via brain freeze ?

 

[boblarson]

Just add

Me.YourListBoxNameHere.Requery

to the form's ON CURRENT event in the VBA window.

 

[soulice]

beautiful! Thx.