yes/no fields

[burton99]

I have added a subform to my form that contains only 2 yes/no fields.

I use it to run reports that tell me rather I have paid a vendor nor not using the yes/no fields in my subform.

However, the only way that the yes/no fields in my subform will work is if I manually go in and check mark the yes/no fields and then uncheck them.

How can I fix this so that the new record in my form will show up in my report without manually going in and check marking the fields and then unchecking them?

Thanks.

 

[FancyPrairie]

If your yes/no controls on the subform are fields defined in a table, then set the default value of the field in your table. Else, set the default value property of the yes/no controls.

You could also use the OnCurrent event of the subform and check for a new record and then set the yes/no controls accordingly.

If (Me.NewRecord) Then
chkYesNo1 = True
chkYesNo2 = False
End If

 

[burton99]

Thank you very much. I will try this and see if it works and will let you know. Thanks again.