bburke- (name?)
Looks like you tried to use the Expression Builder to create your SQL - never do that. It's better to create a query that does what you want, then switch to SQL View and copy what the query builder created.
You need to get rid of <<Expr>> in the two places it appears. Provided you have the field and table name right, that should fix it.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 31, 2015, at 5:14 PM, bburke@swiftaz.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hello John,
I created a form using the Form Wizard and placed two combo boxes on the form. I used this expression in the Control Source of the cmbCarNumber:
= SELECT «Expr» [CarNumber] FROM [tblCars] WHERE «Expr» [CarName] = [Forms]![frmCars]![cmbCarName]
I also created a blank form and placed the two combo boxes on that form I received a 'syntax is incorrect' dialog box after both attempts. I missed something, just not sure what.
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar