Looking at values in 2 seperate fields in a query

[ecalvert47462]

So I have a user form where someone will select Yes if they have a reference number...and then once they select yes they will enter the reference number in the reference number field.

Sometimes the user forgets to select Yes, but puts in a reference number anyways.

I have a report that runs against this query and tells me what has a ref number and what it is.

What kind of query criteria can I use so that they both show up on the report, ones that are filled in correctly and ones that only have one of the two fields in? I used is not null but that only returns the ones where both fields are filled out.

Thank you.


E

[alansidman]

I might do this a little differently. I would grey out (disable) the reference text control until the control that holds the Yes value is in place. It would require you to do an after update event on that control. In this manner, no reference number can be inserted without the Yes being added.

[ecalvert47462]

would that be a hard thing to do?

[alansidman]

No. in the form properties, in the on-load event, set the reference number control to disabled. In the properties for the yes control, in the after update event, indicate an if-then statement that if the control value is Yes, then set the reference number control to enabled.

See below examples

Option Compare Database
Option Explicit


Private Sub Field5_AfterUpdate()
    If Me.Field5.Value = "YES" Then
    Me.Field1.Enabled = True
    End If
End Sub


Private Sub Form_Load()
Me.Field1.Enabled = False
End Sub