Listbox RowSource

[BiggsWolf]

I am new to FoxPro and have what will likely be a simple question:
When a use a listbox and set it’s RowSourceType to “4 – Query (.QPR)” and then set it’s RowSource to a FoxPro query, every time I run it a query window pops up. How do I populate a list box from a query with out a query windows appearing?

Thank-you

 

[danceman]

send the query to a cursor

select your fields from mytable into cursor mycursor

by sending the return results into a curosr, change the rowsourcetype to alias then assign the cursor name (mycursor) as the rowsource. Attitude is Everything

 

[Mike Gagnon]

1. Create a query with the query designer and make sure you specify a destination ( a cursor)
2. In your ListBox make the rowsourceType = 4
3. Make the Rowsource your query .qpr file (fullpath required)

Mike Gagnon

 

[BiggsWolf]

Thank-you, I have it running correctly now.