Subfrom problem

B

B

I have created a subform with Default View as "Continuous Forms" to link
other table - "table A". If there is no record in "table A", the subform
still shows one record row . I have done nothing, but the new record row
suddenly disappears. I can not add any new record. the allow
edits, allow addition, etc are all set as Yes
 
J

John Vinson

I have created a subform with Default View as "Continuous Forms" to link
other table - "table A". If there is no record in "table A", the subform
still shows one record row . I have done nothing, but the new record row
suddenly disappears. I can not add any new record. the allow
edits, allow addition, etc are all set as Yes
Click to expand...

Have you possibly set the Enabled property of the subform control to
False, or its Locked property to True? If not, doublecheck that the
Allow Additions property of the form within the subform control is in
fact Yes, and that the Recordsource property points to a table or to
an updateable query.

John W. Vinson[MVP]
 
B

B

checked

Enable = Yes
Locked = No
Allow Edit = Yes
Allow Additions = Yes

Please Help!!! I am very desperated
 
J

John Vinson

checked

Enable = Yes
Locked = No
Allow Edit = Yes
Allow Additions = Yes

Please Help!!! I am very desperated
Click to expand...

Your form, or your database, may be corrupt.

Try the following steps until it's working:

- Use Tools... Database Utilities... Compact and Repair to fix the
database.

- Create a new, empty database; import everything from this database
into it (to get a clean set of system tables).

- Delete and rebuild the form from scratch.

John W. Vinson[MVP]
 
Top