Hey people.
I have a Database which contains many tables.
One of which is a table that contains information about 5 university modules and their Module ID's, a Pass mark, A merit Mark, and a Distinction mark.
What I am trying to create is...:
A user form which will allow the user to change the values of the Pass, Merit and Distinction.
But as there are 5 modules, there may need to be a drop down list or a listbox of the modules which selects the module then you can change one (or more) of the 3 values in the row.
And also when the user changes one (or more) of the values, I'd like to date stamp the change for future reference.
I'd just like maybe a little guidance on how to achieve this.
Any help appreciated!
I was thinking drop down box listing the modules with a button for each that inserts a new value and a date stamp.
I have a Database which contains many tables.
One of which is a table that contains information about 5 university modules and their Module ID's, a Pass mark, A merit Mark, and a Distinction mark.
What I am trying to create is...:
A user form which will allow the user to change the values of the Pass, Merit and Distinction.
But as there are 5 modules, there may need to be a drop down list or a listbox of the modules which selects the module then you can change one (or more) of the 3 values in the row.
And also when the user changes one (or more) of the values, I'd like to date stamp the change for future reference.
I'd just like maybe a little guidance on how to achieve this.
Any help appreciated!
I was thinking drop down box listing the modules with a button for each that inserts a new value and a date stamp.
