Hi There,
I having been trying to have an if statement work, but have no success. I have attach a pic of what I am trying to do.
I have a form that has data in it and a yes/no check box at the end. The form is looking at data from a query. If there is a check mark in the box, append those records to another data table. But then I don't want the people with the check mark showing in the query anymore.
If I put a cretiera NO, then the append query doens't work.
If this isn't clear, please say so and I will try a different way of explaining it.
This is the only code I have so far, it appends to another table, but then I don't know how to filter out the people who have check marks.
DoCmd.SetWarnings False
If Me.Select = True Then
DoCmd.OpenQuery "qryappend90dayreview"
End If
DoCmd.SetWarnings True
Any suggustions?
Jennifer
I having been trying to have an if statement work, but have no success. I have attach a pic of what I am trying to do.
I have a form that has data in it and a yes/no check box at the end. The form is looking at data from a query. If there is a check mark in the box, append those records to another data table. But then I don't want the people with the check mark showing in the query anymore.
If I put a cretiera NO, then the append query doens't work.
If this isn't clear, please say so and I will try a different way of explaining it.
This is the only code I have so far, it appends to another table, but then I don't know how to filter out the people who have check marks.
DoCmd.SetWarnings False
If Me.Select = True Then
DoCmd.OpenQuery "qryappend90dayreview"
End If
DoCmd.SetWarnings True
Any suggustions?
Jennifer