New Record

[jepoysaipan]

Hi,

Is there a way for my Datasheet View not to show a blank record not unless the user click the Add button?

Thanks in advance!

Happy Thanksgiving

Jeff

 

[boblarson]

Set the subform's Allow Additions property to NO and in the button to add a record, use:

Me.AllowAdditions = Yes

and then in the after update event of the form put the same but with NO

Me.AllowAdditions = No

 

[jepoysaipan]

Thanks a lot!!!!!!

Exactly what I needed.