Thanks in advance for any help rendered!

From a form with a text box that a user would type in the ID number of a record and then hit a submit button (using vbscript and SQL), can you update a field in that specified record. Something like this:

Private Sub Command112_Click()
Find record with value = to Me.TextWithValue and in the [Complete] column make it equal to "true".
End Sub

Again Thanks,
Lee

An update query should do what you want...