Dlookup Vs. IIF

[dicepackage]

I have a function that runs and updates my database by importing e-mail information into Outlook. I currently have a Yes/No field in the database called "lock" that I check once the query has been run so it is not repeating multiple times. I will be doing this multiple times and have noticed it can really bog things down when scanning the folder.

When updating the database I am currently using a Dlookup to check if the field lock is checked. If it is False it will run a query that imports about five fields into my database. I am wondering would it perhaps be any faster to just eliminate the Dlookup statement in favor of an IIF statement to check for the lock field's status.

[OBP]

Can't you add the Lock field to the query and set the Criteria to 0

[dicepackage]

Well that is kind of what it is doing but at some point I need to check whether it is 0 or 1. The real slowdown is it just checking for this.

[OBP]

But is the Lock field part of the Query's fields, if it is you only need to put a 0 in the first Criteria row and it will only allow records that are not locked.

[dicepackage]

No, my lookup is searching a table for ID and then checking for lock status.

[OBP]

Can you post an example database in access 2000-2003 format?