Search results

I'm trying to add a toggle button to a form that will lock and unlock the form to prevent inadvertant editing errors. I've looked up all of the code I could find on this issue and still run into errors and problems (my VBA level is beginner). Any help would be great. I have a form with two...

Here is my query field in a make table query: Date of 3 month f/u due: IIf([Date of IC Review] Is Not Null,([INDEX_DATE]+83),"") But I want the response of ([INDEX_DATE]+83) to be formatted as a date and not as text. The existing table field of INDEX_DATE is already in date/time format...

Fairly new to access and I've searched all over to get the syntax on this right. I have a table with a field [Response] and a field [Index Date] along with an Id number. I've tried this IIF statement but keep getting the Invalid Syntax error - "You may have entered an operand without an...