Forced Entry In Form

[amourdevin]

Is there a way to force the user to enter a new value in a form even if there is preexisting data? It would be OK for the user to enter the same information (confirm the preexisting data) but I want to force the user to enter something.

Thanks in advance!

 

[Remou]

Hi
Do you want the user to enter data in a particular field or just anywhere? If it is anywhere, you could use the OnChange event of the form and a hidden field. If it is a particular field, you could do the same with the field OnChange event. If, for example, the hidden field says "No Change", The user is returned to the valid field until a change is made. It would be easier, I think, if it was a particular field.

 

[TheAceMan1]

How are ya amourdevin . . . . .

[blue]Is there a way to [purple]force the user to enter a new value[/purple] in a form even if there is preexisting data?[/blue]

[purple]What is your criteria for determining wether a user should do that or not?[/purple]

See Ya! . . . . . .

 

[amourdevin]

I would like the user to always be forced to enter something a particular field even if it means redundantly reentering the preexisting data.

 

[Remou]

Hi
How about this:

Private Sub Form_Current()
Me!HiddenField = "Unchanged"
Me!FieldToUpdate.SetFocus
End Sub

Private Sub FieldToUpdate_AfterUpdate()
Me!HiddenField = ""
End Sub

Private Sub FieldToUpdate_Exit(Cancel As Integer)
If Me!HiddenField = "Unchanged" Then
Cancel = True
End If
End Sub

 

[amourdevin]

I am admittedly near clueless.

The field I want to update is a long integer called [ToolRoomEmpID]

I will attempt to work out the syntax correctly on my own but would appreciate help (spoon feeding I suppose) if offered. If I correctly figure it out on my own, I will post that upon success.