btw   I tried to paste the whole code into the forms and GoDaddy didn't let me do it, Blocked reason "you're running a SQL statement"...

Your code looks fine. Check your spelling. Make sure all of your fields are spelled correctly - in the code and in your table. Obviously this code is 4 years old and THOUSANDS of other students have taken it, so I know it works properly. Check the data in your tables. Try REMOVING one parameter at a time and see what happens. And yes, if you try to upload any SQL in the Forums, you'll get blocked by the firewall. Use screen shots.

Got the problem
I just needed to close and open the form to refresh...

I don't understand why for such silly details I need to waste 2 hours in the day :-(
You might ask the same...

getting crazy again........
I was wrong that was not the problem
when I take out this from the code it works
AND SalesDate=#" & SalesDate & "#
y should this cause probs?

Always, always, ALWAYS, check the Troubleshooter before wasting 2 hours trying to figure something out, wasting time Googling stuff, or posting a question. What's the first item on the list (after backing up your database)? Restart Access. That would have fixed your problem right there and saved you 2 hours. Consider it a teaching moment, which is why I don't consider this a waste of my time, because that's my job: to TEACH you. :)

Whenever I see someone in another country having issues with date fields, I always suspect it's a regional date problem. How are your dates stored / formatted?

What do mean in my pc or in this database?

no format at all in the form
the default value in the SalesDate is =Date()
no format in the commissionT for SalesDate

Do all of your records have dates? Null values will cause a problem.

Yes, in the commissionT they are all filled with dates

What does it say if you remove the On Error Resume Next?

ERROR 94

Yeah, that's just invalid use of null. Not sure. I'm stumped with this one. I still think it's a regional setting since you can remove that date and it works fine. And like I said, this course is 4 years old and NOBODY else has had a problem with it. I can verify that the code works as shown on my system. Has to be something on your PC.

I spent ages with a Date issue a few years back, try formatting the date as dd/mm or mm/dd

Also build the WHERE clause in the DLOOKUP as a variable and do a DEBUG.PRINT to see what its sending
Then test that in the immediate window and try it in a SQL statement instead.

Thank you all for giving your time to my errors, I really appreciate it
Alex- I am really sorry to ask but can you please explain this, your speaking like an expert I am just to dev.3
hope you get me...

ID = DLookup("CommissionID", "CommissionT", "EmployeeID=" & SalesRepCombo & " AND SalesDate=#" & SalesDate & "# AND SalesAmount=" & SalesAmount)

=DLOOKUP (Field, Domain, Criteria)

I want to see what the Criteria is so

Dim criteria As String
criteria = "EmployeeID=" & SalesRepCombo & " AND SalesDate=#" & SalesDate & "# AND SalesAmount=" & SalesAmount

So now you have CRITERIA you can do stuff with like
DEBUG.PRINT criteria
Or
MsgBox criteria
Etc

Thanks
it works out that msgbox criteria are good, but somehow it returns a null by the full lookup statement

Can you try converting that to a SQL Query and running it and see if you get a result.

how

You know how to create a Query that has criteria?

Go and review Access Expert 3, Lesson 1. It covers basic SQL.

Also, check and make sure Joe is really EmployeeID 1.