Setting Criteria in Query



Hey Everyone,
I have a table that has a 6 checkboxes and 6 memo notes boxes. Everytime
the checkbox is unchecked the agent has to leave a comment in the notes box.
I am trying to set criteria in a query that basically states if checkbox is
unchecked please give me the notes. My problem is that i have 6 checkboxes
and notes field with each record. Can someone offer insite or a possible
workaround? Thanks


Try this in the form's "before update" event for the first checkbox and memo

If IsNull(Me!memo1) And me.checkbox1 = false Then
MsgBox "The checkbox for the first memo is unchecked. Please enter
some notes", vbCritical
Cancel = True
End If

If you try to move out of the record, it will check whether the memo field
is null and the checkbox is unticked. If it is you will get the message box.

Let me know!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question