Setting Criteria in Query

S

scott04

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
 
S

scubadiver

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

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
Me!memo1.SetFocus
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

Similar Threads

question driven query 6
Checkboxes and Query Criteria 1
Query criteria in a memo field 1
Query with more than 8 'OR' criteria? 2
Criteria based on checkbox 15
fake checkbox based off lookup column 2
Checkbox issue - Checkbox overlapping when filter is applied 1
If Statement with "*" in Query 2

Top