Continuous Form – Stop process of adding a new rec (Access 97 SR-2)

Topic

New Reply

I have a form where users input information about their dependents. When the form open all of their dependents are displayed. The form is set to ADDITIONS = NO. If a user wishes to add a new dependent, they click a button which sets ADDITIONS = Yes. This automatically inserts a new row for them to begin inputting data. However, as soon as they begin typing another row appears below the one where they are inputting data. I do not want this to happen. I have tried resetting the ADDITIONS = No for the form on variuos events (BeforeInsert, afterinsert, etc.).

Does anyone have any ideas?

Thanks,
Sean

Reply | Quote

Replies

From what I’ve experienced … Access ALWAYS shows the current line where data is being entered as well as the next (blank) new record IF you’re allowing additions.

Reply | Quote

The only way around it is to create a new, blank record in code and then requery the form, move to the new record and allow them to edit it. Of course, that assumes your tables will allow a blank record to be inserted–mine won’t, by design.

Reply | Quote