Microsoft Access 2007 - continuous form
Posted on 2010-09-20
I have a continuous form that displays my recordset. I want the user to be able to update one of the fields but I don't want the user to be able to add a new record from this form. So I open the form using acEdit to allow the records to be updated but it also has the new empty row with an "*" for adding the next record.
DoCmd.OpenForm "DAFTracking", acNormal, , strWhere, acEdit, acNormal
Is there a way to "turn off" the empty row at the end of the detail section of my continuous form? Or make it invisible? I tried setting "Allow Additions" form property to No but that didn't seem to change anything. The empty row was still there.
Thank you for the help.