If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IIf function Problem
I am getting an error message that indicates that Access is still trying to
perform the DLookup or "False" when the result should be "True". Here is my code: IIf(IsNull(Me.Days), "No repair time should be allotted.", _ DLookup("Return", "ltblDays", "Lookup = " & Me.Days)) So when Me.Days is tabbed into and out of w/o entry, or an entry is made and then deleted, the DLookup attempts to run but is null and so cannot complete it's Dlookup. Any ideas why the code isn't recognizing a True statement and stopping before running the False?? Thanks so much! Pamela |
Thread Tools | |
Display Modes | |
|
|