On Tue, 4 Jan 2005 10:17:44 -0500, "Jan Il"
wrote:


I have tried the new code in the NotInList event of the cmbTransaction
control, but, when I enter a check number, such as 2001, tab to the next
control and enter the date, then tab to the Transaction control and enter
the new information, then try to tab to the next control, I get an error
that says: Data type conversion error.


and once again you didn't told on which line

I guess:
DoCmd.OpenForm "frmCkEntry", , , "Transaction =" & NewData, ,
acDialog

a string has to be in qutes: therefore

DoCmd.OpenForm "frmCkEntry", , , "Transaction ='" & NewData &"'",
, acDialog

we will give him what he wants.

BTW: how big is your mdb after zipping it?
---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW