VBA to add new row to a continuous form

Moore71

DEVELOPER
Local time
Today, 07:17
Joined
Jul 14, 2012
Messages
158
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)>
 

Users who are viewing this thread

Back
Top Bottom