How to prevent jump to next record.

  • Thread starter Thread starter hoke
  • Start date Start date
H

hoke

I have a form which contains a subform.
When I move through the fields in the subform and reach
the last field in the record, I will jump to the next
record.

How can I prevent this and goto the beginning of the
CURRENT record instead.

The reason for this is that the underlying tables have a
one2one relationship so only one detail record needs to be
created.

Ofcourse the unique index on the reference column will
prevent the creating of two detail records for one master
record.
But I also want the form to be unable to create two detail
records for one master record

thanx in advance
 
I have a form which contains a subform.
When I move through the fields in the subform and reach
the last field in the record, I will jump to the next
record.

How can I prevent this and goto the beginning of the
CURRENT record instead.

The reason for this is that the underlying tables have a
one2one relationship so only one detail record needs to be
created.

Ofcourse the unique index on the reference column will
prevent the creating of two detail records for one master
record.
But I also want the form to be unable to create two detail
records for one master record

thanx in advance
Click to expand...

How about setting the form's Cycle property to Current Record?

- Jim
 
Back
Top