Remove Blank Row on Continuous Form

[JessicaGomo]

On a continuous form, I would like the user will add a new record via button click instead of popping open a blank record at all times. With AllowAdditions set to False on Form load, and turning it back on button click I can get a new record added. I am having trouble determining where to turn it back off.

• AfterInsert - doesn't seem to delete the blank row until I move to the blank row, so this doesn't accomplish what I am looking for.
• AfterUpdate (for each field on continuous form) - this did what I wanted, but I was only able to update one field on the form for the new record. The combo boxes then were viewable, but I could not make a selection.

I am still learning Access but am proficient in VBA. Please help!!

 

[CJ_London]

I would look at the dataentry property as well - and perhaps move the relevant code in onload to the oncurrent event or form afterupdate event