Use DLookup to Retrieve Field Value from a Date?

[Heatshiver]

I have an input form that a user can insert a Start Date and End Date, and then open a report with charts in those date ranges.

I need to populate some of the field values in the report with field values that correspond to the End Date only.

Can I use the DLookup expression for this? I've been trying this, along with other expressions, and can't get the result I need.

 

[plog]

No. DLookup only can retrieve data from queries and tables. You need to reference it using this syntax:
=[Forms].[YourFormNameHere].[TheFieldNameHere]

Replace 'YourFormNameHere' and 'TheFieldNameHere' and you should see the value on the form.

 

[Heatshiver]

Unfortunately, this doesn't help me as it doesn't include a way to reference End Date.

Thanks for the reply.

 

[Heatshiver]

Simplest solution was to use the Criteria of my Date field in the query:

=[Forms]![UserInputFormName]![ControlNameFromUserInputForm]