I am using MS Access 2003 and MS SQL SERVER 2005. I have a form and a subform. When I unlink them, both forms work fine independently, but when I link them, either by the table field name or the form field name, I get an error that simply says Syntax Error. In my current scenario, I have two tables Project_Link and Protocol_Link with Project_Id and Project_ID respectively. Do any of the folks on the forum know how I can overcome this issue?
Thanks in advance, Donald
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.