Solved Update Record in Table with Combo Box Selection

RonieB

New member
Local time
Today, 17:23
Joined
Jun 1, 2022
Messages
22
I have a form with a subform that I would like a combo box on the form to update as records are added to a table via a subform. I used the following code for the subform event AFTER UPDATE, but I get an error that says it cannot find the field. Any suggestions on how to correct so that when data is entered on the subform it adds the seletion per record on the subform?

Private Sub SSOW_AfterUpdate()
Me!SEsIni = [Forms]![frm_WI_Entry].Combo51
End Sub
 
yes, I did read it. I just didn't understand so thought showing it to you might help me understand. Thanks anyway.
 
Thank you for the time and effort of explaining this and I understand greatly now. I had added the est initials to the subform but that didn't work for me but now I understand why. The subform will have many records added for the main number. The same est will do that and have been conditioned to do this. But Isee your point and will adjust.
Again, thank you so much for the assist.
 

Users who are viewing this thread

Back
Top Bottom