I'm just learning coding in Access and I had to write this code (below) for a form, but I'm sure this is not truly the best or most concise way to write this...How could I have written this more simply? I know there's got to be a better way...
Code:
Sub TrackingRequery()
Me.cboYear1.Requery
Me.cboYear2.Requery
Me.cboYear3.Requery
Me.cboYear4.Requery
Me.cboYear5.Requery
Me.cboYear1.Value = Null
Me.cboYear2.Value = Null
Me.cboYear3.Value = Null
Me.cboYear4.Value = Null
Me.cboYear5.Value = Null
Me.cboYear1Percent.Requery
Me.cboYear2Percent.Requery
Me.cboYear3Percent.Requery
Me.cboYear4Percent.Requery
Me.cboYear5Percent.Requery
Me.cboYear1Percent.Value = Null
Me.cboYear2Percent.Value = Null
Me.cboYear3Percent.Value = Null
Me.cboYear4Percent.Value = Null
Me.cboYear5Percent.Value = Null
End Sub
Thanks in advance for helping me on this silly question...