R
rburna
I have a form and I need to change several values depending on a drop
down, I do not want to have to use the column references to do this.
I have the following code in place
DIM strSQL As String
strSQL = "Select [TestColumn1], [TestColumn2],[TestColumn3] FROM TEST
WHERE RowNum = 1"
DoCmd.RunSQL = strSQL
Me.txtColumn1 = ??
Me.txtColumn2 = ??
Me.txtColumn3 = ??
I know there has to be a way to reference the recordset but I can't
seem to find it.....
Any help is appreciated....
Thanks,
Richard
down, I do not want to have to use the column references to do this.
I have the following code in place
DIM strSQL As String
strSQL = "Select [TestColumn1], [TestColumn2],[TestColumn3] FROM TEST
WHERE RowNum = 1"
DoCmd.RunSQL = strSQL
Me.txtColumn1 = ??
Me.txtColumn2 = ??
Me.txtColumn3 = ??
I know there has to be a way to reference the recordset but I can't
seem to find it.....
Any help is appreciated....
Thanks,
Richard