Fill date field with last date
Posted on 2014-12-09
I have a form which has a date field named "Date of Previous Visit". For the control source I'm trying to use:
But it doesn't like that. Note that the query is a query that returns just the last record, not using DLast because I've learned that won't work. Instead it is a select query returning just one record in descending order.
What is wrong with my control source?
I also tried:
Me.txtDateOfPreviousVisit = Queries!qryLastPatientVisit.[Start Date]
in the oncurrent event of the form but it didn't like that either.