J
Jay
I have a table which includes two fields 'Status' and 'Date Resolved'.
'Status' can be either 'Ongoing' or 'Resolved', and is controlled by a
combo box on the form.
I want the 'Date Resolved' field to be automatically populated with the
current date when the user changes the 'Status' to 'Resolved', to save
the user having to type the date in.
Can anyone advise how this can be done, bearing in mind I'm a bit of a
novice.
Many thanks,
Jason
'Status' can be either 'Ongoing' or 'Resolved', and is controlled by a
combo box on the form.
I want the 'Date Resolved' field to be automatically populated with the
current date when the user changes the 'Status' to 'Resolved', to save
the user having to type the date in.
Can anyone advise how this can be done, bearing in mind I'm a bit of a
novice.
Many thanks,
Jason