p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access VBA (http://p2p.wrox.com/forumdisplay.php?f=80)
-   -   No additions using VBA and SQL (http://p2p.wrox.com/showthread.php?t=53692)

Bob Pierce February 6th, 2007 11:28 AM

No additions using VBA and SQL
 
I've set up a simple form based on a two table join, using VBA and SQL. Eg:

Me.Form.RecordSource = strSQL

This form doesn't allow me to edit or add records and I can't see why. I've set up the same form using the form Wizard and this one does allow edit and add. The only difference between the properties of the two is the Record Source which is a stored Query on the Wizard version, and blank for my original. The content of my strSQL is exactly the same as the SQL in the Query.

What am I missing?

Bob Pierce February 6th, 2007 01:20 PM

Me again. Sorry to have wasted your time, my SQL wasn't exactly the same as the Query - now it works.


All times are GMT -4. The time now is 02:07 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.