Thanks Tracy - Interactive change works! Is it by design that the refresh is only executed immediately from the Interactive vChange?
Thanks, Joe On Wed, Apr 24, 2024 at 10:00 AM Tracy Pearson <tr...@powerchurch.com> wrote: > Should the code in the Lost Focus event actually be in the Interactive > Change event? > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe > Yoder > Sent: Tuesday, April 23, 2024 9:53 PM > To: profoxt...@leafe.com > Subject: Fwd: List box issues > > Thanks to Fletcher for the cursor clue I am closer to what I want. > > I have 2 files: > Spaces with fields space_id and descript > Units with fields : unit_id, space_id, and descript > > I have a form with a list box for each > the Spaces list box has the row source set to 6 (Fields) of Spaces > the Units list box has the Row Source type set to 3 (SQL Statement) > and the Row Source to: > select Spaces.Descript from Spaces where Units.space_id = > Spaces.space_id int cursor xxx > > The Spaces listbox lost focus event has the following code: > thisform.list2.requery > this form.list2.refresh > > For some reason the Units list box does not display updated data before I > click on another box. Actually clicking any other buttom causes the box to > update. > > What am I missing now? > > Thanks in advance. > > Joe > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cabqednvaiore1ljacq2g+2xafnid+e3w4zle_thykybgxtp...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
