Hello,
Although a beginner I have created a 2 sheet document where sheet 1 is a form (using formatting not userforms) that when completed populates an adjacent sheet 2 (in effect a database), I have done it so that each entry (form completion on sheet 1) is allocated a database reference on the database page (sheet 2), however I would like to have that database line reference from Sheet 2 displayed on the original form sheet 1, because that reference is used for modifying or deleting the record. I guess the reference doesnt exist until the sheet 1 form is saved - perhaps it would have to "predict" what the number is going to be? Any ideas?
Although a beginner I have created a 2 sheet document where sheet 1 is a form (using formatting not userforms) that when completed populates an adjacent sheet 2 (in effect a database), I have done it so that each entry (form completion on sheet 1) is allocated a database reference on the database page (sheet 2), however I would like to have that database line reference from Sheet 2 displayed on the original form sheet 1, because that reference is used for modifying or deleting the record. I guess the reference doesnt exist until the sheet 1 form is saved - perhaps it would have to "predict" what the number is going to be? Any ideas?