Recent content by dbaldwin117

Thank you. That did it.

In Access 2007, I have a form with a subform. The under lying tables are related one to many with referential integrity. When I display a specific record in the parent form, I would like the most recent related record to display in the sub form. The parent form's table has unique client info...

I have found numerous errors in my code since posting this. I now know that trying to populate fields in a report record after opening a report is not an available option. I need to recall the syntax for opening a report with a specific record based on a field value in the current record in a...

Is there a way to include a date input mask in the date entry prompt triggered by a date parameter in a query? I have a parameter condition of "Between [Start Date] And [End Date]" in a date column in a query.

I need to use a non-key field that is not indexed but will not allow duplicates. How can this be done?

I need to use a key field that is not indexed, but will not allow duplicates. How can this be done?