Search results

I am trying to prevent duplicates in a form entry in Access 2007 I am trying to use this code in the beforeupdate section of the form Private Sub cmdClearForm_Click() Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acComboBox ctl.Value = Null Case acTextBox...