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?