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

0 commentaires:

Enregistrer un commentaire

Labels