N
New_help_needed
Please help, I'm new to this.
I created a form (based on one table) which is used to enter records to the
db.
Form contains "item" field and "memo" field.
In to memo field will be entered number and this number may be repeated
(many times) but ones in a while the number will be increased by 1.
I would like to default this “memo†field on the form to the max number from
the memo column in db (NOT the last record). If the memo number will need to
be repeated, value will be accepted just by hitting enter, if value will need
to be increased, new value will be entered.
Actually I was able to do it,
= Max ( [MEMO_TB]![MEMO] )
but the correct (max) memo number appears in the field while entering third
record already. For some reason does NOT work for the first and the second
record. If anybody has any idea, I will greatly appreciate help. Thanks
I created a form (based on one table) which is used to enter records to the
db.
Form contains "item" field and "memo" field.
In to memo field will be entered number and this number may be repeated
(many times) but ones in a while the number will be increased by 1.
I would like to default this “memo†field on the form to the max number from
the memo column in db (NOT the last record). If the memo number will need to
be repeated, value will be accepted just by hitting enter, if value will need
to be increased, new value will be entered.
Actually I was able to do it,
= Max ( [MEMO_TB]![MEMO] )
but the correct (max) memo number appears in the field while entering third
record already. For some reason does NOT work for the first and the second
record. If anybody has any idea, I will greatly appreciate help. Thanks