I’ve been batting this around this morning and can’t seem to find the answer.
I have a form that gets updated periodically with Funding updates.
The Current Yr Allowance only changes once every Fiscal Year so, I want this field to default to the latest FY value for each Location. I had used a combobox to select the value but, I’m trying to eliminate that extra step and just have the program automatically put the latest value in.
I tried using DLookUp in the Default Value but, it’s not working.
Attached is part of the database that deals with this.
Any help would be appreciated!
I have a form that gets updated periodically with Funding updates.
The Current Yr Allowance only changes once every Fiscal Year so, I want this field to default to the latest FY value for each Location. I had used a combobox to select the value but, I’m trying to eliminate that extra step and just have the program automatically put the latest value in.
I tried using DLookUp in the Default Value but, it’s not working.
Attached is part of the database that deals with this.
Any help would be appreciated!