Access key replication

%3CLINGO-SUB%20id%3D%22lingo-sub-2130483%22%20slang%3D%22en-US%22%3EAccess%20key%20replication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2130483%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%2020%20database%20with%2020%20Plus%20tables%20and%20and%20over%2040%20queries%20(%20not%20to%20clued%20into%20VBA.)%20I%20had%20the%20whole%20system%20working%20fine%20but%20now%20suddenly%20one%20of%20my%20first%20tables%20is%20giving%20problems.%3C%2FP%3E%3CP%3EWhen%20I%20try%20add%20a%20new%20Product%20to%20%5BTblPrdoList%5D%20is%20is%20applying%20an%20existing%20prime%20key%20.%20The%20form%20opens%20and%20shows%20a%20%22new%22%20key%20but%20when%20i%20tab%20off%20the%20first%20input%2C%20it%20offers%20me%20an%20existing%20Key.%20(obviously%20the%20item%20will%20not%20save)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20entering%20data%20direct%20into%20the%20Table%20and%20get%20the%20same%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20table%20ProdID%20settings%20are%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Field%20size%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Blong%20integer%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BNew%20values%26nbsp%3B%20%26nbsp%3Bincrement%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Indexed%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BYes(no%20duplicates)%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BText%20Allign%26nbsp%3B%20%26nbsp%3B%20general%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20cant%20find%20anything%20wrong%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20must%20say%20that%20I%20have%20had%20this%20and%20related%20tables%20all%20working%20perfect%20before..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIvan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have created a 20 database with 20 Plus tables and and over 40 queries ( not to clued into VBA.) I had the whole system working fine but now suddenly one of my first tables is giving problems.

When I try add a new Product to [TblPrdoList] is is applying an existing prime key . The form opens and shows a "new" key but when i tab off the first input, it offers me an existing Key. (obviously the item will not save)

 

I have tried entering data direct into the Table and get the same result.

 

The table ProdID settings are      Field size     long integer

                                                     New values   increment

                                                    Indexed     Yes(no duplicates)

                                                     Text Allign    general

 

so cant find anything wrong

 

I must say that I have had this and related tables all working perfect before..

 

Any help appreciated

 

 

Ivan

0 Replies