Compile Error: Argument not optional

[tariq1]

Hi, I am receiving the error with the code below, thank you for your assistance




Compile Error: Argument not optional

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me![FirstName].Value = Tariq Then
MsgBox ''Tariq already exists''
Cancel = True
End If
End Sub

[June7]

If Tariq is a literal string then must be enclosed in quote marks.

[John_G]

To elaborate on what June7 said - you have delimited your string Tariq already exists with pairs of single quotes - instead of a pair of single quotes, you need to use double quotes:

"Tariq already exists"

The compiler is interpreting the first of your single quotes as the start of a comment following MsgBox, leaving MsgBox with no message, thus the error

John

[June7]

Good catch, John, I didn't even notice those were single quotes. My comment was about the string Tariq in the If condition.

[Missinglinq]

In addition, testing for duplicates on a Field is normally done in the BeforeUpdate event of the Control where the Field Value is entered, not in the Form_BeforeUpdate event.

If you only want one Record for 'Joe,' you want to find out that 'Joe' already has a Record immediately after entering his name, not after entering all of his data for a second, unnecessary time, when the Record is being saved!

Linq ;0)>