
How do I create a query then use data bound controls on the query
@cts.com
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: CTS Network Services
Newsgroups: comp.lang.basic.visual.database
Use the query as the data control's recordsource:
data1.recordsource="SELECT * FROM mytable..."
When you refresh the data control, the recordset will be composed of the
selected records.
Chris
Quote:
>I want to projece a query to extract certain records from a table, then I
>want to use the data bound controls on the query projuced.
>How can I do this from within VB4, The database is in dbase format.
>Thanks
> Brian.