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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Key Violation on SQL Insert -- Makes No Sense!
After a week--once I post a message, I figure it out. For some reason, the SELECT works with just the command name, but for the INSERT one needs to use Forms!FormName!CommandName.Text.- valerie
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Key Violation on SQL Insert -- Makes No Sense!
I am trying to insert data into a table based on user input into a combo box (whenever the user types in something not in the list, it adds that value to the underlying table), using the following SQL syntax: INSERT INTO TableName (PrimaryKey) VALUES ([Forms]![Formname]!cmbComboBoxName)...- valerie
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
