After connecting the checkbox to the yes/no data field in the table, thatReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7246-yes-no-field-table-make-exclusive.html
worked great. Thank you very much! Have a good wknd!
> Validation rules apply to the data in the current record, so it can't be
> used. But you can loop through the recordset, and accomplish this in the
> checkbox' AfterUpdate event:
> ' If field in current record is checked, set all others to false,
> ' essentially creating a multi-record option group.
> On Error Resume Next
> Dim rst As DAO.Recordset
> Dim intindex As Integer
> ' Remember ID of current record
> intindex = Me!YourPrimaryKeyID
> If Me!YourCheckBox = True Then
> ' Create recordset clone, loop through all records
> Set rst = Me.RecordsetClone
> Do Until rst.EOF
> If rst![YourPrimaryKeyID] <> intindex Then
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7246
> With rst
> !YourYesNoField = False
> End With
> End If
> ' Clean up
> Set rst = Nothing
> End If
> "Karl H" wrote:
> > Hi,
> > Can you have a yes/no field in a table that will have a validation rule that
> > only one rowsource can have the "yes" choice selected? This would allow for
> > declaring that row source the default.
> > The validation rule would need to state, If "yes", then all other records in
> > the same table = no.
> > Is this possible? What would the expression for the validation rule be?
> > THank you,
> > Karl