Recent content by AdamMVRRS

Thank you - both work! I knew there was a simple way to do it :rolleyes:

Hi All, I was hoping that you could help me today. I'm trying to create a query that will eventually become a report. It's based off the back of a current query that I use, but I just can't seem to figure it out. We are a training company, so the existing report tells our Health and Safety...

Bump - Could anyone help? Or am I a lost cause :P

Hi Everyone, Sorry for posting a thread that pops up a lot on the internet, but I haven't been able to find a solution in the past couple hours of searching. I'll try to explain my situation the best that I can. I have a form with a few tabs and 3 subforms. I used the following Audit Trail...

I just used the input existing fields when I made it

Private Sub NI_number_BeforeUpdate(Cancel As Integer) Dim Answer As Variant Answer = DLookup("[NI_number]", "LearnerDetails", "[NI_number] = '" & Me.NI_Number & "' AND [MVRRS_Learner_ID] <>" & Nz(Me!MVRRS_Learner_ID, 0)) If Not IsNull(Answer) Then MsgBox "Duplicate National Number Found" &...

Silly me. Now I'm getting access can't find the field MVRRS_Learner_ID referred to in your expression, but the field name is exactly the same?

Yeah I've got them in there :(

Now I'm getting Compile Error Expected list or separator ) This is just highlighting the second line in yellow even when I change the PK to my primary key :( __________ This is what I have right now: Private Sub NI_number_BeforeUpdate(Cancel As Integer) Dim Answer As Variant...

Private Sub NI_number_BeforeUpdate(Cancel As Integer) Dim Answer As Variant DLookup("[NI_number]", "LearnerDetails", "[NI_number] = '" & Me.NI_Number & "' AND [PrimaryKeyField] <>" & Nz(Me!PKField,0)) If Not IsNull(Answer) Then MsgBox "Duplicate National Number Found" & vbCrLf & "Please enter...

Am I meant to be changing the bold to MVRRS Learner ID?

Still getting a syntax error :( and yes my PK is an autonumber I don't enter that!

I just seem to be getting a syntax error. I've tried it as you wrote it and I've changed what you said as primary key to my primary key "MVRRS_Learner_ID" but no luck

I'm not totally sure what you mean, sorry you're talking to a relative novice. Do you mean the function is looking at the same record that's why it's returning the error?

Any data I enter into the NI Number field at all is saying it's a duplicate - even a 'j'. If it did work, when you click okay the field will not save unless you change the NI Number, sometimes we will need to have the same number on two records for a learner doing two different levels, so I...