View Single Post
  #11  
Old May 15th, 2009, 01:01 AM posted to microsoft.public.access.tablesdbdesign
Russ[_2_]
external usenet poster
 
Posts: 52
Default 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.