Re: insert one at a time

Daud wrote in message ...
>Hi All
>
>Is it possible to create a form that will only allow user to insert
>one record at a time. What I mean is that whenever a record is
>inserted, it has to be saved first before the next one can be
>inserted. Some goes for update.
>
>Thanks.
>
>rgds
>Daud

Daud,

There are many ways to do this. One of the easier and more secure ways is to set the block to insert allowed property_false, and force users to use a special button or menu option when they need to create a new record. When users try to do this check the record status of the current record and if it equals 'INSERT' then stop new record creation. In order to create a new record via your button you will need to set insert allowed on, create a record, then set it off again.

Steve E. Received on Thu Oct 31 2002 - 17:41:50 CET