If...Elseif...Else...Endif question

[RobinAG]

I'm having a wierd difficulty with my If...ElseIf...Else...End If statement.

I'm having the db put together a string to base a recordset off of, and depending on the ID number, the select statement changes.

Basically it looks like this:

If Me.ProjectID.Value <=1835 Then
str = _Select statement 1
 
ElseIf 1836 <= Me.ProjectID.Value <= 5109 Then
str = _Select statement 2
 
Else
str = _Select statement 3
 
End if
 
Set DB = CurrentDB
Set rst = DB.OpenRecordSet(str)

For IDs under that fit under the first two conditions, the code works fine, but when it falls under the last "else" condition, it doesn't register for some reason.

Am I doing something wrong in this statement?

[missinglinq]

Your problem, I think, is in your line

ElseIf 1836 <= Me.ProjectID <= 5109 Then

It should be

ElseIf 1836 <= Me.ProjectID And Me.ProjectID <= 5109 Then

As you have it set up, there is no 3rd condition; you have

Me.Project <=1835

and

Me.Project >=1836

Linq ;0)>