Recent content by RandomUser

I'm sorry but I can't.

Next, I'm trying to put a code in for when "Valve #" is populated , AND the "Location" is null, a prompt appears to remind the user "Please enter the valve Location!" Ive tried putting this into the BeforeUpdate and Private Sub VALVE_#_BeforeUpdate(Cancel As Integer) If Not...

This is strange, the code from earlier worked. Private Sub Not_Exercised_AfterUpdate() If [NOTES (NOT EXERCISED)] = "UNABLE TO LOCATE VALVE" Then [EXERCISED] = "NO" End If End Sub

My mistake, the field name is "NOTES (NOT EXERCISED)", not "NOTES"

Private Sub Not_Exercised_AfterUpdate() Me.[EXERCISED] = IIf([NOTES] = "UNABLE TO LOCATE VALVE", "NO", "YES") End Sub Error occurs, highlighting [NOTES (NOT EXERCISED)] and says "external name not defined"

Exercised data type is short text Do I put Me.[EXERCISED] = False at top, underneath the Private Sub line?

First of all, I'd like to let you know I am an absolute newbie at coding and I'm trying to write some of my first coding for an Access program I put together. I'm trying to implement rules for specifics fields in the input screen. The fields are used while I conduct a survey. I'd like to...