Iterate through records to check if value exists

[SimonPGreen]

Hi,

I have a table and one of the fields is a boolean datatype and i need to ensure that only one record has this set to -1

Access to this field is via a form and I would like to trap the before update event on the tick box bound to the field, iterate through the records to check the flag status and then either update or msgbox the user and exit if the flag is already set.

Any idea on the best way to achieve this.

Appreciate any help.

Regards,

Simon

 

[genomon]

Is the database small enough to use DLookup or DCount (takes overhead on large mdb's)? Could see if "where booleanvariable = 1" returns anything and go from there...

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[SimonPGreen]

Thanks Genomon,

Records limited to about 20 so overhead shouldn't be an issue.

Regards,

Simon