Right now on my program I have it so when the user clicks on a certain item in the combobox, it moves to that item. All I am using is

VB Code:
  1. Do Until ID.text = newValue
  2.      If newValue > oldValue then
  3.           Me.RecordSet.MoveNext
  4.      Else
  5.           Me.RecordSet.MovePrevious
  6.      End If
  7. Loop

Now this works fine...It moves the bound items to the correct record, however, if I allow the form_current event to run directly after this, I receive the error

Quote Originally Posted by Runtime Error '2115'
The macro or function set to the BeforeUpdate or ValidationRule for this field is preventing [Beta] from saving data in the field.
This happens on line

VB Code:
  1. txtCourse.Text = ""

However, if I run the above loop, and stop form_current from running. Then run a commandbutton with this code

VB Code:
  1. Thinger = False
  2. Form_Current

Where thinger is the variable I used to stop form_current from running.

The program runs fine??


This has been stumping me for a good number of hours already, and any help would be appreciated