access expected: list separator or )

Question

I've created a form with a subform linked by a numeric ID.  When I populate the first field of the subform I receive the message "expected: list separator or )".  When I click ok on the message, the field populates, the associated macro runs and I am able to complete the record.  Any edits of the information in the records does not generate the error.  I have tried rebuilding the underlying tables and recreating the forms but the problem persists.

The only way I've found to get rid of the error is to remove the link between form and subform.  Of course, this is not functional but it indicates that the problem is in the link.  I have created a separate database with a form/subform linked by a numberic ID and did not experience the same problem.  Any help?

Answer 1

I agree that there's some stray code causing this. Try typing Ctrl-G to open the VBA editor and select Debug... Compile to compile the database's VBA project. Correct any code errors.

You may also want to post the form's and subform's Recordsources (post the SQL) and the Master and Child Link Fields - one of them might be flawed.

Answer 2

Just another thought - could it be that you have used any Access Reserved Words for the names of the fields which you have in any of the main form or subform's record sources?

Answer 3

No.  I have not written any code for the subform and the only macro associated with the subform runs after I populate a field with a combo selection.  Than the macro requeries the form and opens a query to update another field on the form.  

The problem still occurs when I remove the macro and only occurs when I add a new record.  If I have created the record, I can update any field in the record and the error does not occur.

Answer 4

I've created a form with a subform linked by a numeric ID.  When I populate the first field of the subform I receive the message "expected: list separator or )".  When I click ok on the message, the field populates, the associated macro runs and I am able to complete the record.  Any edits of the information in the records does not generate the error.  I have tried rebuilding the underlying tables and recreating the forms but the problem persists.

The only way I've found to get rid of the error is to remove the link between form and subform.  Of course, this is not functional but it indicates that the problem is in the link.  I have created a separate database with a form/subform linked by a numberic ID and did not experience the same problem.  Any help?

My first guess would be that there's code or a macro running in the subform's Dirty or BeforeInsert event, and there's something going wrong in that code.  Could that be the case?