Printable View
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.
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.
Oh, so there is more to this. If its already refreshed and requered, then you can make the selection selected by going.
.ListIndex is the index number of the combo item that is currently selected in the listVB Code: