a Complicated situation for me.
i Have a 2 tables in access with the same Field saying BANF_Nr which sees like " -BANF-0001"
here this 0001 is an Autonumber like 0001,0002,0003,0004 and so on
i have a textbox in Form txtbanf which should call automatically the next number from this field..suppose there is BANF-0028 the last ones..now when i go to this form the txtbanf.text should be automatically filled by BANF-0029.
this BANF-0029 should not get saved unless i click the button SAVE.
i tried to attach some jpeg files for your convinience but couldnt..
Please help me friends in getting this code..