What are the numeric digits to the left of " =" (without the quotation marks)?
Example
Code:
Me.id0 = Me.Studyinfo.Column(0)
Shouldn't that be
Code:
Me.id = Me.Studyinfo.Column(0)
that is, isn't the form control name is "id", not "id0"?
Each of the other form control names in the subject also have a trailing numeric digit. I suspect each is incorrect.
Code:
The yellow bar means that there is a line of code which does not compile. It may or may not be the line high-lighted.
Compile your code to see if it compiles. The Access compiler process stops at the first erroneous line. Fix each successive the error and recompile until the program compiles error free.