A
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.
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.