Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Link Form to SubForm

Status
Not open for further replies.
dnfrantum

dnfrantum

Programmer
Oct 23, 2001
175
US
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
 
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Use domain accounts to log in to Access database
Replies
0
Views
291
breezett93
breezett93
techstudent01
  • Locked
  • Question
Convert MS Access SQL queries to AIX SQL queries
Replies
0
Views
258
techstudent01
techstudent01
InspectorHound
  • Locked
  • Question
Creating an MS Access 2013 project with multiple forms
Replies
1
Views
291
lameid
lameid
batteam
  • Locked
  • Question
Importing Excel data to SQL table using MSAccess .adp
Replies
3
Views
273
lameid
lameid
LittleNick
  • Locked
  • Question
Can Quick Access Toolbar be disabled in Access 2010?
Replies
0
Views
264
LittleNick
LittleNick

Part and Inventory Search

Sponsor

Back
Top