>If I have a combo-box (Referred to as comStates) that contains the Names of States of the USA and this Combo-Box's Control Source is thisform.cState_Name
>
>My Second Combo Box would Contain the users of that state based upon
>the Value of the first combobox. I would do a SQL Statement in the Rowsource of the 2nd comboBox that said something like...
>
>Select * from States where st_Name=thisform.comStates.Value into Cursor comNames
>
>Of course, this will Puke... I was wondering how a more 'Seasoned' approach to this would be??
>
>Thanx Much!!!
>Bob :-)
you'd want to use a variable instead of an object value. you'd also want to requery the cursor in the first combo box lostfocus event.