Force users to update a field

[Arjay418]

Hi,

Here's the problem:

On Form 1, a user will enter a value into a field (Field: Status; Value=New).

Later, on Form 2, another user will need to update the field (Field: Status; Value=Updated).

How can I force the user to update this field? Is there a way to get Access to look at Field Status on Form 2 and make sure it doesn't say "New"? If it does, can it prompt the user to change Field Status to something else?

Thanks,

RJ

 

[jrbarnett]

Something like:

If Me.txtStatus = "New" Then
  MsgBox "Please update the status field", vbOkOnly
End If

Put this in the BeforeUpdate event of the form so it will get triggered when somebody tries to save a record.

John

 

[Arjay418]

Brilliant! I wasn't famliar enough with the form's BeforeUpdate property to know that was the right event. Can I also prevent the user from proceeding to the next field?

Thanks,
RJ

 

[randy700]

Have you making the change without the user doing it? No matter how many "reminders" you give the users, they can still ignore them and not make the changes.

For instance, in the After Update event, include code something like....

strSQL = "UPDATE [i]yourtable[/i] " & _
   "SET Status = 'Updated' " & _
   "WHERE RecID = " & me.RecID
DoCmd.RunSQL strSQL

Randy

 

[jrbarnett]

The form's beforeupdate event gets triggered immediately before a record gets saved, it sounds like you need to move that to the BeforeUpdate event of a control (same code, but add Cancel=True before the End If line), but it does mean that you need to handle the fact that they could use fields out of order.

John