No duplicate records problem

On Thu, 14 May 2009 17:15:55 -0600, John W. Vinson
wrote:

On Thu, 14 May 2009 17:08:05 -0500, Russ wrote:

John,

I was able to delete the record after entering your code, but the form
will not insert a digit into the ItemNo field (I've renamed and
removed the # symbol and replaced them with "No") when I insert a new
record.

Please post your code, and indicate the datatypes of your fields. If either of
them are Text fields instead of Number you need to tweak the code a bit.


My two fields in question are both text fields. I can probably change
them to Number if you think it will work better.