I have a main form, subform 1 and subform 2 for entering Donor information. The subforms are linked to the main form with master/child fields, donor id. When a donor is added to the database, three tables are updated: tblDonors, tblContacts, tblNonProfitDonors. The record source for the main form is tblDonors, which requires a record before records can be added for tblContacts and tblNonProfitDonors. Records are updated with the following on-click event procedure, which is tied to the save button on subform 2.
Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click
On subform 1, I use an if then statement to disable a text box based on the value selected for a combo box on the same subform. All works fine with the first add, but I have a problem refreshing subform 1 when doing multiple adds. I need to enable the text box that was disabled from the previous add. Currently, this requires that I close the main form and reopen. I've tried to add refresh/requery to the event procedure, but I believe this hasn't worked because it is tied to subform 2. I would greatly appreciate any help and I am glad to submit the database to anyone willing to take a look.