Recent content by santoshrnath

Hi All, There was no design flaw. It was just VBA coding Flaw which i resolved it myself. Thanks for all your response the code used is Option Compare Database Option Explicit Public Function SequenceNewLevel() Dim strSQL As String Dim strSQL1 As String Dim db As Database Dim rs As...

I have attached a test file, i want the sequence from ID table to Mastertable. And update the master table max ID value to ID table.

The code works fine, but it only looks for activity. It does not check level. Also it does not update back the max value from Mastertable to ID Table.

Hi, Actually the field is there, but was not shown in the screen shot

I have two tables, ID table and Mastertable. In ID table i have level and activity which is given a start number, let us say 1000. In Mastertable i have many drawings associated to the same activity and level. I have to provide numbering to them starting from the ID table value 1000 and...