Hi all,

I am having trouble getting a date field in a table to auto fill when a certain status is chosen from a combo box within a form. Specifically, I have a field called "Status" (Combo Box) in a form and one called "Closed Date" (Date/Time) in a table and want today's date to fill when the Status is changed to "Closed". I have been perusing several forums and threads, and have not been able to pinpoint this specific issue. All that I have been able to do is create a macro that populates the date when any status is chosen from the "Status" combo box. The macro has an Action of "SetValue", and under the Argument: Item is [Closed Date], and Expression is Date(). I cannot get it specified to only fill when the status is changed to "Closed". Any help would be greatly appreciated!

Thanks