Hi Marcia,
Does that mean this should work?
If This.Valid()
ThisForm.AddQuery()
EndIf
Also, is this only the case for comboboxes? (The textbox controls seem to work how I expect them)
Thanks,
James
>Helo James.
>
>
I can't explain why it is doing what it is doing, but I could only get it to work if I change the InteractiveChange to:
>
>>If This.Value = "AND" or This.Value = "OR"
> REPLACE AndOr WITH this.value
> ThisForm.AddQuery()
>EndIf
>
>
>Of course, it seems as if the REPLACE shouldn't be needed...???>
>That is because the ControlSource is not updated from the Control's Value until the Valid fires.