I have a data entry form which uses vba to loop over some stuff and enters multiple records. This works, except for one problem. It generates an extra record (appearing first, before the others) where the list box field looped over is blank.
This is fixed by setting the data entry property of the form to "No", however, when I do this, upon opening the form all the combo boxes are filled with an existing record. I do not want this, I want all combo boxes to be blank when I open the form. How can I do this?
This is fixed by setting the data entry property of the form to "No", however, when I do this, upon opening the form all the combo boxes are filled with an existing record. I do not want this, I want all combo boxes to be blank when I open the form. How can I do this?