"Add new record" not auto assigning auto number

[Elfman]

HI All,

My Problem:

- I have a qry made up of 2 tables
- 1 of the tables has an autonumber primary key
- a made a form from this qry
- It all works fine except that when I go to add new record
it dosen't assign a new number for this filed and i get an "invalid use of null"
error

any thouhgts on what could be causing this ?

any help at all would be great

- Elfman

 

[Rabbie]

Really wierd. Any chance you can post your DB or at least that form and table so we can see why it isn't working?

 

[missinglinq]

My first guess would be that your query isn't updatable! If you open the table and add a new record is the Autonumber created? Ditto for the query itself?

Allen Browne has an excellent white papaer explaining this and giving some workarounds.

http://allenbrowne.com/ser-61.html

Linq