Search results

I have a form that uses a dlookup to populate a text box from a combo box. It worked but recently it has stopped. I am working on the entire database so I created a copy to work on. Not only has the dlookup stopped working in my copy but in the original as well. I didn't change anything that...

I appreciate all your help. At this point I'm ready to go in a different direction. I'll let you know if I need anymore help. Thanks to all who tried to help.

OK That worked. So I guess there's no hope for my form.

It let me input the data once with no errors. But I can't try a duplicate.

OK So it's not working because the training number is an autonumber and I'm not able to input the number I need.

It has been a long day and I'm sure it must be late for you. I'll try this and see how it goes. Thanks.

Sorry but I didn't get the attached db. I am using mmddyyyy. I wouldn't be surprised if this form is corrupted. It is an old database that has been used hard.

As soon as I insert this code it turns red.

I have an input mask set for short date.

Same thing except change training_number to employee_id Runtime error 3075 syntax error (missing operator) in query expression '[Employee_ID]= AND [Date_Completed]=##'

Runtime error 3075 syntax error (missing operator) in query expression '[Training_Number]= AND [Date_Completed]=##' And this is happening when I try to exit the form using the quit button. And it still lets me put in duplicates.

Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("*", "TBL_EmpTrainDate", "[Employee_ID]='" & Me.Employee_ID & "' And [Training_Number] = " & Me.Training_Number & " AND [Date_Completed]=#" & Me.Date_Completed & "#") > 0 Then MsgBox ("A Record for this Employee, Training Class and...

It is definitely in the Before Update.

The values are exactly what I entered. Employee ID is ssn, Training Number is 5 and date is 3/1/2013

I'm sorry. No offense but you just spoke Greek (or is that Geek) haha. I'm not a programmer in any sense of the word. My expertise is in hardware. So I guess I'll need more instruction.

I tried that. I then entered some data and tried to quit the form and got an error. Runtime error 3075, syntax error (missing operator) in query expression '[Employee_ID]=" And[Training_Number]= AND[Date_Completed]=##'

Where are you putting this code?

This is a HUGE db filled with confidential data so I'm really don't think I can. It would be nearly impossible to remove the data.

Thanks for trying. It still isn't working. Not sure where I'm going from here.

1) Text 2) Autonumber 3) Date/Time