VBA to add new row to a continuous form (1 Viewer)

Hi,
I have a continuous form that I set it add new record property to no. So how do I add new row with button if I need to?

You can change the form's AllowAdditions property, then use GoToRecord to go to the new record. Or if you know the values, you can add a record to the underlying table and then requery the form.

You'll also need to set the AllowAdditions property back to No/False, after entering the New Record...but all of this begs the question...Why have AllowAdditions set to No/False in the first place, if adding New Records is going to be allowed? We do this sort of thing with the AllowEdits Property, in order to prevent the users from accidentally overwriting data in an existing Record, but what is the need for this in allowing the addition of New Records?

Linq ;0)>