Add 1 new record only

[merry_fay]

Hi,

I've got a simple form showing the contents of a table with add new record disabled.
There's a button to add a new record which, if the criteria are met, takes the user enables additions & takes the user to a new record. One of the fields is automatically filled.
This all works fine, my problem is that, when the field is filled (the new record comes into existence), another new record appears under it.

Is there any way I can stop this from happening?

I'm trying to re-disable additions after the new record is created, but it seems to be losing focus on the new record as it does that & because some of the fields in my table are required, it comes up with a fault.

Is there a way around this?

Thanks
merry_fay

 

[gemma-the-husky]

its because if you have a form that allows additons - the new addition row is always available - so when you start to edit the new record, you then get the next new record.

the only way round this is to keep the form in "no additions" mode - and maybe open a new form in single view, to allow entry of a new record, remove navigation controls, set the cycle property to current record

then add a "Save Button" which closes the form. Then you need to requery the original form, to see the record you just added.