david_johnson
Registered User.
- Local time
- Today, 15:54
- Joined
- Oct 12, 2017
- Messages
- 12
So I canNOT figure out what is wrong with my dlookup language. I used the table references just to make certain its clear. I want to look up a value (mthly_rpt_period_month) in "monthly_report_period" based on the user entry in combo box "mnthly_rpt_due_date" on the form "Switchboard" based on the correlating field "mthly_rpt_period_due_date" that's also in the "monthly_report_period" table.
=DLookUp(" [monthly_report_period]![mthly_rpt_period_month] ","monthly_report_period","[monthly_report_period]![mthly_rpt_period_due_date] = ' " & [mnthly_rpt_due_date] & " ' ")
=DLookUp(" [monthly_report_period]![mthly_rpt_period_month] ","monthly_report_period","[monthly_report_period]![mthly_rpt_period_due_date] = ' " & [mnthly_rpt_due_date] & " ' ")