Warning flag on Form

[gls]

Hi

Hopefully someone can assist me with this. I have a table and a form.

tblAccess & frmAccessDetails

The table has many fields, but one is called job_closed. On the form, this field is a combo box with 2 options that the user can select, yes or no. it always defaults to no unless the user changes it on the form to show yes.

When the users work through the many thousands of records on the form, I would like a flag/message box to pop up and say "job is closed" if the field job_closed for that record = yes. So this would be a quick reference for users.

Can you help

Thankyou

Garry

 

[pbaldy]

One way would be to use Conditional Formatting to highlight that field in some way (text or background color, bold, etc).

 

[gls]

Thankyou, I'm looking for something that would be a little more in your face. A message box would be great so they need to read it and click ok to proceed to the next job.

Thankyou

Garry

 

[pbaldy]

Then code in the current event:

If Me.job_closed = "Yes" Then
  MsgBox "closed"
End If

 

[gls]

Thanks Paul, worked like a treat. Just wondering, is there anyway to change the colour of the message box to red?

Garry

 

[pbaldy]

Not that I'm aware of.