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 ---