Hi Andi :-)

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

W'll.....I can't tell you which 'line', as again, it does not give any line
reference information as to what part of the code is causing the error. All
the error message consists of is: Error: Data type converstion error. That's
all. g

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.

'k.....I cut and pasted the above code, making sure it is all on one line,
and I still get the same error message. Again, it is not giving any line
reference as to what is causing the error.

BTW: how big is your mdb after zipping it?

I'm using a sample test copy, which has limited files for test purposes, so
it's only 166 KB zipped.

Jan