If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Syntax Error or Access Violation on Form/Subform
When opening a form with a subform, I get the error: Syntax Error or
Access Violation. It appears to be related to the Link Child Field and Link Master Field properties. I want to link the forms by a field called Template_Name that appears in both forms. If I remove the field from either the Child or the Master, the error goes away but the results in the subform are not filtered to match the form. This is an ADP database. When I had this in form in an MDB, it worked properly. Any thoughts, suggestions, workarounds? Thanks |
#2
|
|||
|
|||
Syntax Error or Access Violation on Form/Subform
|
#3
|
|||
|
|||
Syntax Error or Access Violation on Form/Subform
The data type for the field is nvarchar in both tables. I managed to
get it to work by recreating the subform. Don't know why, but it works now. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Make the syntax in Access consistent | aoeusnth | General Discussion | 1 | April 7th, 2005 05:59 AM |
CREATE PROC syntax in ADP | aaron kempf | General Discussion | 2 | December 5th, 2004 03:01 AM |
syntax to run PL/SQL stored proc via ms access pass through query | Edwinah63 | General Discussion | 2 | June 23rd, 2004 03:47 AM |
Open.text macro fn syntax | cuckoonuck | Worksheet Functions | 1 | May 30th, 2004 03:09 AM |
Syntax of excel | Tapani Tuominen | Worksheet Functions | 2 | March 30th, 2004 09:12 PM |