Validation rule in relation to another field name?

[ekulz]

Hi,


As the title says, I was wondering how to create a validation rule in relation to another fieldname in the same table?
For example, the first field line is the serial number, and when something is entered for the serial number the OTHER field line (which is quantity) needs to be 1, otherwise it stays blank.

I use access 2007 or 2010 depending what computer I'm using.

Thanks, Luke

[alansidman]

In the AfterUpdate Event for the fieldname1 containing the serial number,

If IsNull(me.fieldname1) Then
me.OtherFieldName = Null
Else
Me.OtherFieldName = 1
End If

[ekulz]

In the AfterUpdate Event for the fieldname1 containing the serial number,

If IsNull(me.fieldname1) Then
me.OtherFieldName = Null
Else
Me.OtherFieldName = 1
End If

Hi,
Thanks for your answer but I'm not sure that's what I'm looking for. Where you said OtherFieldName = Null (otherfieldname being quantity) I think i want to rephrase that. The quantity can be either zero, or any number other than one to make fieldname1 (serialnumber) blank.

Hopefully I made myself a bit clearer

[ekulz]

Nevermind, solved it myself.

([Quantity]=1) Or ([SerialNumber] Is Null)