PDA

Click to See Complete Forum and Search --> : Me.Refresh / Me.Requery not sufficient [Resolved]


CodeNemesis
Feb 23rd, 2005, 12:46 AM
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
Feb 23rd, 2005, 07:49 AM
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
Feb 23rd, 2005, 09:52 AM
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