Refresh list after using combo list

[jetb2]

Using Northwind DB / Orders Form as an example. When you choose a different bill to in the combo list the address information refreshes. When I do that once in my form it populates the fields but if I choose another it doesn't. How do I repopulate all the fields?

 

[PHV]

Compare the properties and the events of your combo vs northwind.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jetb2]

Thanks, I've been looking at all the columns and even comparing the Visual basic script. Nothing stand out as different or as 'use me to refresh your fields'

 

[postermmxvicom]

I am pretty new to this, but I have done something like that doing the following:

Private Sub AfterThisDate_AfterUpdate()

Me.HeatSearchSubform1.Requery

End Sub

This code was in the event property "after update" of a combo box in the main form, and updated my subform.

...sooo, maybe you should be looking for a requery in your example in an event property somewhere?

One last thing: Sometimes I wonder; "Is that someone's signature? Or do they type that at the end of each post?