Jul 23rd, 1999, 11:26 AM
With the following code I can't seem to get the one record I am querying to show up in the textbox,,,
I always seem to get the first record of the db all the time...
HEEEELLLPPPPP
Thanks,
Marc
Private Sub Form_Load()
With Adodc1
.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.3.51;Persist _ Security Info=False;Data Source=O: _\SHARED\SST\ACCESS\Training\Training.mdb;"
.RecordSource = "Select * from _
landings Where landings.empno=089336"
End With
Set Text1.DataSource = Adodc1
Text1.DataField = "expdate"
End Sub
I always seem to get the first record of the db all the time...
HEEEELLLPPPPP
Thanks,
Marc
Private Sub Form_Load()
With Adodc1
.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.3.51;Persist _ Security Info=False;Data Source=O: _\SHARED\SST\ACCESS\Training\Training.mdb;"
.RecordSource = "Select * from _
landings Where landings.empno=089336"
End With
Set Text1.DataSource = Adodc1
Text1.DataField = "expdate"
End Sub