[bjones]

Hi I'm working on an applicaiton for work (but I'm a sales guy ) and I'm stuck on the Data Environment when it comes to passing paramenters at runtime. I've purchased a few books on VB6 but most of then brush over DE at best. I have setup my connection, commands and built a few forms using the DE but I'm confused when setting up SQL statements within the DE that need parameter passed, say through a text box.
Ideally I would like a user to enter in a year through a textbox, then click a command button that in turn refreshs a datagrid filtered by year...but first things first - what is the proper way to setup a SQL driven Command? Do I simply enter SELECT * FROM tblquotafile WHERE year = ? - then what method to I use to push a variable in "?" at runtime?

Any help here is much appreciated - if anyone knows a good book that covers DE in more detail it is appreciated

Regards, Brock

[thava]

i think the following link will help you

http://www.dreaminco...snippet2492.htm