Recent content by judyjacobse

Hi David! Thank you so much for your interest and help! I checked the VBA code and it worked! This is the solution I found and used with succes this morning: Me.treatmentnr = Nz(DMax("[treatmentnr]", "Tbl_treatment", "[ID]&[tumornr]= " & Me.IDr & Me.tumornr), 0) + 1 Judy

Hi, I have a question concerning the automatically sequential numbering of a primary key as part of a composite primary key. I know there have been previous threads about this topic, but i just can't figure it out... Hopefully someone else can. This is what my data look like: Tbl_treatment...