Autonumber form and subform question

[Helen269]

I have a form and subform as shown below. The Order Number in the main form and in the subform is entered manually but of course ideally the Order Number should be an autonumber.



I've tried to change it by going through the steps to change the number field in the table that the subform is based on to an auto number (delete the relationships, make the change, put the relationships back).

Both Order Number fields should be of the same type otherwise I can't make a relationship between them and the Order Number in the subform won't automatically be the same as in the main form.

The trouble is, being an autonumber, once I start to enter item no.2 on the subform the Order Number field goes to 2 when it should still be Order Number 1.

Is there a way of making the Order Number field an autonumber but have the subform keep that number on records higher than 1?

Thank you.

[Helen269]

It's ok, solved it. Thanks :-)