View Single Post
  #1 (permalink)  
Old February 6th, 2007, 11:28 AM
Bob Pierce Bob Pierce is offline
Authorized User
 
Join Date: Apr 2004
Location: LEOMINSTER, Herefordshire, United Kingdom.
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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?
Reply With Quote