Me.Refresh / Me.Requery not sufficient [Resolved]

[CodeNemesis]

Me.Refresh / Me.Requery not doing what i want.

Here's the scenario: I have a main form (Form A) with a few listboxes. When I double click on one listbox another form pops up (form B) which also has a listbox. When i close Form B the value from there is sent to Form A, but I need this value to display without me having to click the dropdown arrow. I hope I'm being clear enough.

[Ecniv]

frm1 -> frm2

frm2_OnClose (or onUnload) you need to do something like

frm1.controlname = listcontrolname

No need for refresh or anything, unless its bound to a table, in which case you may need a refresh and if its access there may be an issue around sending the updated cache. The latter you'd have to look into.

[RobDog888]

Oh, so there is more to this. If its already refreshed and requered, then you can make the selection selected by going.

Form1.Combo6.ListIndex = Form2.Combo7.ListIndex

.ListIndex is the index number of the combo item that is currently selected in the list