Hi Everyone,
I am new to the forum and am by no means an Access expert. I'm having trouble with a Rules Database I am working on in Access 2016.
The database I have includes two main tables: Rules and Dates. Both of these tables have date fields. I have created a form based on the Rules table. I would like to have the option to select a date from a field in the rules form and have other date fields auto-populate based on the closest future dates in the Dates table. It seems like I could put something in the criteria for the row source of the combo box. But I'm unsure about the criteria and field I should put in the query.
Any help is much appreciated.