Changing the SQL statement in the Data Environment Designer Dynamically

Hullo...

I'm trying to, well no, sorry, I *have* connected my database to my VB program via the data environment designer, and also a secondary link via the ADO...

Using the ADO I can dynamically change the data shown using:

frmMain.dbaccess_controls.RecordSource = ("SELECT * FROM customer_account WHERE customer_number = '" & txt_custNum.Text & "'")

followed closely by:

Call frmMain.dbaccess_controls.Refresh

Now this allows me to have a search form... is there any way I can do this using the data environment designer?

i.e. similar to the above code?

Your befuddled...

Chris!

http://www.vbforums.com/showthread.p...ht=CommandText