Limiting Database Query For UserName

[tempoman]

Can someone help a newbie in Visual Basic .NET.

I currently have a form which checks to see if the username is present in the database and if so checks the password.

I am using the Data Adapter Configuration Wizard to access the database. However I can't see to be able to access the form values in the "Query Builder"

-------------------------
SELECT OwnerID, OwnerSname, [Password]
FROM Owner
WHERE (OwnerSname LIKE '%Form1!UserNameBox.[Text]%')
-----------------------------

This doesn't work. Can the form access be done here or does it have to be done on the actual form, something like this (with the where clause insert somewhere here)?

----------------------------------------------

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Users1.Clear()
OleDbDataAdapter1.Fill(Users1)
Me.BindingContext(Users1, "Owner&quot.Position = 0
End Sub

-------------------------------------------


Thanks alot for any suggestions

Richard