I have a small problem. I'm trying to make a small prototype of a system I made in Ms access for a presentation.
Well basically I have this problem with record set in a small function

Private Sub Varenrliste_Change()


Dim Resultat As Recordset
Dim Dbs As Database

Set Dbs = OpenDatabase("c:\My documents\presentation.mdb")
Set Resultat = Dbs.OpenRecordset("SELECT * FROM Vare WHERE Vare.Varenr=Varenrliste.Text;")

Varenavntext.Text = Resultat.Fields("Varenavn")
Varebeskrivelsetext.Text = Resultat.Fields("Varebeskrivelse")
Varepristext.Text = Resultat.Fields("Varepris")

Resultat.Close
Dbs.Close

End Sub


Varenr is an integer and so is Varenrtext.text
however everytime I try to compile it says:

Run-time error 3061:
Too few parameters. Expected n.

can anybody please help me