Incrementing a number by 1

[chrisjrice]

I have a form which has been created over a linked table. I want one of the key fields to automatically increment by 1. I cannot alter the design of the field to auto number because the table is linked.

I have created a query which gets the maximum number for that field on the database. However when I set the default value n the form to the query + 1 it just comes up with name#?.

Can anyone help, is there another way to do it?

 

[insanity]

There is a great document available from Access Archon (http://www.helenfeddema.com/access.htm) relating to Records numbers and autonumbers, look for No. 49.

I learnt most of my VBA from that site!

Good luck

Peter

 

[chrisjrice]

Thank you very much for the link. It looks like a very informative website.

Thanks

Chris