Continuous Forms - Insert New Record

[Al Williams]

I have a form with 4 combination boxes. To give the user the ability to
change the items displayed in those combination boxes, I have created 4
editing forms. Each of these forms is based on the tables used by the
combination boxes and each of those tables has an autonumber field and a text
field.

When I use the table as the form’s Row Source for any of the 4 editing
forms, a “new†record is displayed and I can insert new items into the table.
When I use queries with the Row Source, two of the forms display the “newâ€
record and the other two do not. The two forms that do not display the “newâ€
record also will not allow me to select the text box (it is Enabled and not
Locked) nor can I select the Delete or Save command buttons on the editing
forms.

I’d like to know why. As near as I can tell, the form properties are
identical for all 4 editing forms and the queries differ only in names used.
The combination box tables are linked to the main form’s table using Enforce
Referential Integrity and Cascade Update Related fields. Thanks.

 

[Tom van Stiphout]

On Sat, 19 Sep 2009 18:16:02 -0700, Al Williams

I bet you that if you open the query directly it cannot be added to
either. That is normal for certain types of queries, e.g. totals
queries and union queries.

-Tom.
Microsoft Access MVP

 

[Al Williams]

The queries are Select queries.
--
Al Williams

On Sat, 19 Sep 2009 18:16:02 -0700, Al Williams

I bet you that if you open the query directly it cannot be added to
either. That is normal for certain types of queries, e.g. totals
queries and union queries.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

So are Totals queries and Union queries (just check the first word in the SQL
statement), and certain outer-join queries and a whole list of other types of
queries that are not updatable.
Did you perform the test I suggested?

-Tom.

 

[Al Williams]

You are correct. Two of the queries allow insertion of new records and two
do not. I still do not understand why.