Log in

View Full Version : Solved: Form/Subform Issue



jauner
12-16-2005, 10:33 AM
I have a form with several related subformswhen I am at the end of the records or there are no records in the table. It creates a blank record in the table and related sub tables. How do I stop Access from doing this?

Example I use the record navigation button to go past the last record. It gives me a blank record screen. If I close the form that record is created.

Justinlabenne
12-17-2005, 05:55 PM
Change the forms "AllowAdditions" Property to No.

Right-click on the form's corner in Design View > Properties > AllowAdditions (No)

jauner
12-20-2005, 10:42 AM
I found some code left by the previous developer that was causing problems. Works good now.