The following code is connected to the After-Update event of a Text Box. When the code runs, I get an Error 2001: You canceled the previous operation. This happens only for vSeries, not for vMfgDate. Does anyone have any idea why this is happening?

Thanks,

Ray


Private Sub SN_AfterUpdate()
Dim vMSG As String
Dim vSeries, vSN As Variant
Dim vMfgDate As Date


vSeries = Nz(DLookup("[PumpType]", "Test Stand Data", "[SerialNumber]=Form![SN]"), 0)
vMfgDate = Nz(DLookup("[Date]", "Test Stand Data", "[SerialNumber]=form![SN]"), 0)

This happens to me all the time! Your DLookup has invalid syntax.

Not sure what your field names are and all, but try this:
Note the brackets [] around the table name. That may be the only problem.

If [SerialNumber] is a Text field, use:
Also, since Date is a reserved word in VBA, I would rename the field [Date] in your table. And make sure you are using correct field names. And for future reference you should, wherever possible, avoid spaces in the name of any object. If [Test Stand Data] didn't have spaces you may not have had an error... and I wouldn't be writing this and admonishing you for your naming conventions. :D

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Randall .... thanks for your reply. I tried your code, but that didn't work either. I understand your concern about naming conventions and I usually try to avoid the things you mentioned. I didn't design this particular table, I've linked to another persons database to grab this data so I'm kind of stuck with it. :(
One thing that confuses me is that the second line of code works and the syntax is the same. Thanks again for taking the time to answer my call for help.

Ray

Possibilities:

• [PumpType] is not the field name in [Test Stand Data], this would cause the original error.
• Change your "Dim vSeries, vSN As Variant" to two separate Dim statements.
• [PumpType] is returning the correct value but you don't trust it.