I have uploaded a version of the database that can be viewed. You'll notice I was trying a view methods: ListBox, ComboBox, and a list example I was trying from another forum posting.
I can get all 3 methods to show just the records for the chosen user ID, but I can only get the ListBox and ComboBox to populate the values and past dates of user "0001". The list example does not change anything, just displays past information.
To use it, open frmUserID and input either "0001" or "0002". This will open frmGenSum. You can then click the ListBox or ComboBox values and see their values for "0001", or get an error for "0002".
If I do choose "0001" I can't change the date to save as a new date with the same information from a previous date (which would be extremely helpful). The bigger issue is that I need to get all users to show their previous date values, so information can be altered in the record.
Any help would be much appreciated!