Affichage des articles dont le libellé est Remove Blank Row on Continuous Form. Afficher tous les articles
Affichage des articles dont le libellé est Remove Blank Row on Continuous Form. Afficher tous les articles

Remove Blank Row on Continuous Form

jeudi 26 février 2015

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!! :)

Remove Blank Row on Continuous Form

Labels