I have uploaded a condensed version of my database. The database has three forms, a user ID form, a main form, and a subform. It has two tables. Click on the user ID for and put in 0004, this will bring you to the main and subform.
There are two major problems:
1) I have a code that verifies if the user ID and date have already been used. It works and alerts the user that the date they are trying to use with the user ID has already been used. But it still creates a new record that does not have a date. I have to figure out how to avoid this, or have it undo that new record.
2) I have a combobox and find record button that are meant to be used to look at an old date to change records, or to use those old values for a new record. My combobox and find record button do not bring up any of the past record values for the main or subform. The combobox will show all the previous dates for the user ID, but once a date is clicked, it will not show that date's values. Instead it retains the current values displayed, if any. The find record button is forced to be on dates, but will not recognize any past dates and states that there is no record with that date (when there actually is). I could likely do without the find record button, but the combobox really needs to work.
A minor problem is that I cannot get the subform to carry over it's old value. I have a checkbox and a date box on the main form. When a new date is inputted and the checkbox is checked it is meant to bring over all the values to a new record. This does work for the information that is not part of the subform. I am thinking I would need to have specific code to copy over the subform information, or another button within the subform...