Default vale in MS Access form

Question

Hi ,&nbsp;I am seeking your help to find the best way to do a settings in the forms label&nbsp;&nbsp;The &nbsp;requirement is as follows , I have a feild named “proposal Number “, in tabled named “ proposal “. I have created a form to enter the data , the proposal Number is a manually fed sequence number . I would like to have the label to recommend the number , based on the highest value on the feild +1 &nbsp;. ( Normally the number is entered sequentially by checking the earliest Entry )&nbsp;I tried to use the MAX function &nbsp;in “Default &nbsp;value “properties as =MAX( [Tablename]![feildname] )+1 , but this is returning 0 , not the real value&nbsp;&nbsp;Can &nbsp;you please help me here . Thank you for your support in advance&nbsp;&nbsp;sincerely&nbsp;&nbsp;John K&nbsp;&nbsp;

arnel_gp · Answer

LJKPRO&nbsp;&nbsp;you change your Expression using DMax():&nbsp;=Val(DMax("ProposalNumberField", "YourTableNameHere") &amp; "") + 1

ljkpro · Answer

arnel_gp&nbsp;&nbsp;Thank you so much it worked !!!!&nbsp;&nbsp;

Forum Discussion

Default vale in MS Access form

2 Replies

Resources