Hello

How do you change the recordset from one access table to another

within the same form? i want to test a query in an If statment within

a Select Case for two separate tables. Here is part of my code...

Select Case rstRecordSet!Difficulty

Case "Easy"
MsgBox "Your level is set to easy"

If txtUser.Text = rstRecordSet!Username Then

Msgbox "test"

Else
sqlstring = "INSERT INTO tbleasy (Username) VALUES ('" &

txtUser.Text & "')"

conConnection.Execute sqlstring, , adCmdText + adExecuteNoRecords

End If


rstRecordSet!Difficulty is in one table and I want rstRecordset!

Username to relate to another table.

Thanks in advance

Piglet