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 The Spaces listbox lost focus event calls the requiry event of the Units listbox to update the choices that appear in the Units list box Each time the SQL executes the results show up in a query window on the screen. How do I suppress the unwanted display? Should I use another technique? Thanks in advance. Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CABQeDnXXz0K3J4Rutp4t=eh-G=9vfbzuf0sb71ewtstap9q...@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.
