How do I pass a Value from a form txtBox to a SQL ADODC RecordSource statement on the same form.
Posted on 2003-10-24
I am somewhat new to VB6. Here is my quandary. I have a form with a DataGrid on it, I have a field with a PASSED value from another form, that is PASSED on form load.
I need to have the SQL statement in the ADODC, RecordSource select the record from the database based on the value from the form field (that was passed).
select Est_No,Est_Notes,Est_Opening_Date,Est_Opening_Location,Est_Opening_Time,Est_Value from tblEstInfo Where Est_No = [this is where I need it to select the record based on the PASSED value in the txtEstNo text box]
Any help would be greatly appreciated????
Thanks in ADVANCE