D
Diane
I'm stumped. I have two forms, each of which has a subform based on a
simple three-field table. One of the subforms displays properly and
allows me to enter data, the other doesn't. I have checked all
properties of both subforms and they are identical. The underlying
tables are identical (except one field name). The forms on which the
subforms sit are both based on updateable queries.
Here are the details on the one that's not working:
I'm linking Neighborhood events to City Council ward(s) that overlap
said neighborhoods. The main form (frmEventInformation) is based on a
query which pulls information from the Events table (time, date, etc.)
and the Neighborhood Association table (contact info, etc.). The
complication is that not all events in the database are sponsored by
Neighborhood associations, so the Events table has optional contact
information fields that become visible when users select the "other"
option in an option group. This action also makes visible a subform to
allow entry of related Ward numbers. The subform is not totally blank,
in that the background color shows up, but there is no line to enter a
new record.
An identical subform on the form that shows Neighborhood Association
info is working perfectly.
Help!
simple three-field table. One of the subforms displays properly and
allows me to enter data, the other doesn't. I have checked all
properties of both subforms and they are identical. The underlying
tables are identical (except one field name). The forms on which the
subforms sit are both based on updateable queries.
Here are the details on the one that's not working:
I'm linking Neighborhood events to City Council ward(s) that overlap
said neighborhoods. The main form (frmEventInformation) is based on a
query which pulls information from the Events table (time, date, etc.)
and the Neighborhood Association table (contact info, etc.). The
complication is that not all events in the database are sponsored by
Neighborhood associations, so the Events table has optional contact
information fields that become visible when users select the "other"
option in an option group. This action also makes visible a subform to
allow entry of related Ward numbers. The subform is not totally blank,
in that the background color shows up, but there is no line to enter a
new record.
An identical subform on the form that shows Neighborhood Association
info is working perfectly.
Help!