Autonumber is not incrementing and is locking the field

[Wetmig]

I am working on an Access DB which is tracking production scrap.

I have the user enter in all finished goods that the were produced that day. I have a query bounce that information against a BOM and make a list of all components that are to be used. The relationship in the "SQL Statement Builder" query is to include all records in the query and only matching records in the record table.

I want the form to pull all this information together and have the user enter the records for each component in each finished good. There are no matching records because the user has not entered them yet, and all the fields on the record table are blank. I expected the table to generate an autonumber after I entered information into the form. Instead, because there was no autonumber, the form is not allowing any entry into the table via either combo box or manual entry.

Does anyone have any suggestions? Thank you for you help.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886