Forms-New User Keeping Monthly Info

[DLMitch]

I have a form based on a table with item numbers. I want to be able to have the user enter the item number, date, price and it will retain this information in the table so that queries may be run "how many items were enter from this date to this date"
Problem: when I type in item number and all information for the next month it overrides the previous month info, is there a way to have it keep this information.
Any help would be greatly appeciated. Thanks.

 

[pcs]

you need to change your table design to include an AutoNumber field to be used as the primary key or composite primary key.

hth,
al


[This message has been edited by pcs (edited 03-23-2002).]