SQL and textboxes - won't work

[C.D]

Hi, I've got this problem that drives me mad.
I've been trying to search the forum, but it's impossible to get good results..

I'm working on a DB, where I'm trying to limit the results based on textboxes.
strSQL = "SELECT * FROM [qryAnimeFansubberEpisode] WHERE [AnimeFanID] =" & Me.AnimeFansubberID & " AND EpisodeID Between txtFrom and txtTo" - I've tried different variants, but it says Too few parameters
Between # and # works though..
What am I doing wrong?

Thanks in advance!

 

[RuralGuy]

You need to do the same thing with Between txtFrom and txtTo that you did with [AnimeFanID] =" & Me.AnimeFansubberID & "

 

[KeithG]

strSQL = "SELECT * FROM [qryAnimeFansubberEpisode] WHERE [AnimeFanID] =" & Me.AnimeFansubberID & " AND EpisodeID Between #" & txtFrom & "# and #" & txtTo & "#"