>>I have a form with two combo boxes. The output from the first (i.e. the controlsource - say Thisform.var1) is to be used to determine the data displayed in the second combobox by means of a filter based on var1 in an SQL statement in the RowSource. What is the best way to pass the controlsource to the SQL statement? Thisform.var1 is not allowed in the SQL statement in the rowsource. I have got round it by using a private variable in the form but I feel this is not the correct way to do it.
>
>Here's another approach (albeit written before we had BindEvent):
>
>http://tomorrowssolutionsllc.com/Articles/granr09.PDF
>
>Tamar
Thanks for the input Tamar. Nice to see a bit of good old code still very usable. :-)
Barry.