Correct Code/Parsing?

[csdrex87]

Ok so I have the basic outline for how to check for duplicates but my problem now is when im comparing two different text fields that have text/numbers EX:

Enter the week/month (drop down menu with Aug/01, Aug/02, Aug/03)
ect.

I have my code to check the Emp_ID with the table and to attempt to compare the week/month but it blows up. Both of these have to be compared. Can someone help me with this code?

Code:
iEmpId = DCount("Emp_ID", "tblEmployeeWeekly", "Emp_ID = " & Me.Emp_ID & " And Month/Wk=" & Me.Month / Wk & "")

 

[pbaldy]

This should help, plus you'll have to bracket the field/control name due to the inadvisable spaces and symbols.

http://www.mvps.org/access/general/gen0018.htm

 

[csdrex87]

Thanks! That was exactly what i needed it all works perfect now