SELECT statement question (1 Viewer)

Set dbSAP = CurrentDb

On Error GoTo Err_Exit:

'select from Redirects Table
strSQL = "SELECT * FROM ReDirects WHERE Redirect = True"
Set rstRedirects = dbSAP.OpenRecordset(strSQL, dbOpenDynaset)

MsgBox(rstRedirects!Name)


The above code will select the first record from ReDirects even though all the records have the field Redirect set to False. I would expect it not to return any

What do you get if you just run this SQL in a new query...
Your WHERE clause might fail that way if the your 'Redirect' field is not boolean.

Mark

i just realised my mistake, another part of the code was setting the first records Redirect to true before calling this code. Its all working now