autonumber and continuos form

[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.

 

[gol4]

dmax will alway return same value.
need to do something like

=dcount(field", "table","Where recordid >recid&quot