Continuos forms and autonumber

[nadir66]

hi
i have a problem that keeps me going fo rthe last 2 days.
i have a continuos form, that i fill with data for manufacture formulas, and all the numbers need to be generated at that point. my problem is that this is a subform, so it does not get refreshed, and when i use dmax
=dmax("field", "table&quot+1 , the new(second) line is a duplicate. how can i solve this problem?
Thank you for your time.

 

[fneily]

I created a main form with a subform. The subform's main field is incremented using your formula. I place it on the field's Default option. It works fine. If I stay on the same main record, the subform increments all right and if I go to a different main record, the subform field starts from where it left off. Where do you have the formula?

Neil

 

[nadir66]

i have the formula on the field default value. it just looks like it does not refresh...