>>is it possible to use the where clause in the SQL select
>>statement a combobox i've been using
>>select title from myData where title ="X"
>>my combobox is filled with every title from myData
>>all the x's, all the y's, and all the z's
>>and a query browse which i don't want
>>is filled with the correct data only the X's
>>Can i do what i want to do and can i get rid of the browse window
>>thanks in advance for any help
>
>Steve, if I've understood you correctly you're trying to use a SQL statement to populate your combobox?
>
>First make sure that the RowSourceType is SQL. Then in RowSource put the actual SQL statement:
>
>SELECT title from myData where title ="X" into cursor cTemp order by Title
>
>This will put your data into the cursor cTemp, and order it alphabetically. If you don't use the "into cursor xxx" clause your SELECT will simply show in a browse window just as yours did. You may have to do a thisform.mycombo.requery() in the form INIT to show the data.
>
>HTH
>Barbara
Barbara
Thanks for your help
steve