Update list box

soulice

Registered User.
Local time
Today, 05:18
Joined
Dec 21, 2011
Messages
41
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 ?
 
Just add

Me.YourListBoxNameHere.Requery

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

Users who are viewing this thread

Back
Top Bottom