DLookup not working

[lastout]

I have a Dlookup in a sub that isn?t working. The sub?s purpose is to add a new value to a list in a combobox. When the user enters a new value, a data entry form pops up and they can add the new value plus some other fields pertaining to the new record. The user then clicks the save button in the popup form, and then the close button. At that point an error message comes up saying ?You have cancelled the previous operation.? When I hit the debug button, the Dlookup line of code is highlighted:

Result = DLookup("[Agent]", "tblAgent", "[Agent] = " & NewData)

Does anyone know what is wrong with the line (I'm working with Access 2002)?

Thanks in advance!

 

[BanditWk]

Several immediate issues I see is to make sure the variable "Result" is Dimmed to the same datatype as that as "Agent".

Then, if the variable "NewData" is of string type, it needs to have quotes, such as this:

Result = DLookup("[Agent]", "tblAgent", "[Agent] = '" & NewData & "'&quot

Good Luck! Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)