Heatshiver
Registered User.
- Local time
- Today, 15:20
- Joined
- Dec 23, 2011
- Messages
- 263
I just went through normalization, and now I'm going insane from subform mishaps! I've been trying to find and implement solutions for the last 5 days with no luck.
The setup:
I have uploaded a condensed version of my database. There are two tables, and three forms - one being a subform. You first open the UserID form and type in 0004. This will lead you to the main form with the subform.
The issues:
1) The subform is shown but with just the data for the one date I have added it to. I cannot change the data in the subform at all... If I change the date and save, it just saves over the previous record. In other words, the previous record is deleted, and a new one is saved in its place.
2) I have a verification in VBA so that if the date and user ID have already been used, a small message is meant to appear. This had previously worked when I was using a separate table for user ID, but now that I have it in the same table as date, it doesn't verify at all it seems. Instead, it will save an extra record of the same date.
3) I have a combobox and a find record button so that previous dates can be displayed. The user can then use a checkbox I have setup that will carry over the old values to a new date of their choosing. However, the combobox no longer changes any of the values on the form, but it does display all the known records for that user ID. The find record button states it cannot find a date even if it is a valid date. This too had worked when I had user ID as its own table.
These problems only occurred once I performed normalization and had to use subforms to connect the data. The main table has a relationship to a foreign key of the secondary table.
Any and all help would be welcome. I really need to get this data connected and working properly. If not, I can only think to resort to my previous database, which would be improper "form". Thank you!
The setup:
I have uploaded a condensed version of my database. There are two tables, and three forms - one being a subform. You first open the UserID form and type in 0004. This will lead you to the main form with the subform.
The issues:
1) The subform is shown but with just the data for the one date I have added it to. I cannot change the data in the subform at all... If I change the date and save, it just saves over the previous record. In other words, the previous record is deleted, and a new one is saved in its place.
2) I have a verification in VBA so that if the date and user ID have already been used, a small message is meant to appear. This had previously worked when I was using a separate table for user ID, but now that I have it in the same table as date, it doesn't verify at all it seems. Instead, it will save an extra record of the same date.
3) I have a combobox and a find record button so that previous dates can be displayed. The user can then use a checkbox I have setup that will carry over the old values to a new date of their choosing. However, the combobox no longer changes any of the values on the form, but it does display all the known records for that user ID. The find record button states it cannot find a date even if it is a valid date. This too had worked when I had user ID as its own table.
These problems only occurred once I performed normalization and had to use subforms to connect the data. The main table has a relationship to a foreign key of the secondary table.
Any and all help would be welcome. I really need to get this data connected and working properly. If not, I can only think to resort to my previous database, which would be improper "form". Thank you!
Last edited:
