M
Mike
I have a userform with a 2 option button's in a Groupbox. I would like to use
these as the criteria of a query if possiable. The option buttons value's are
1 and 2.
So I thought I could say............In the Criteria of TENDER_TYPE
IIf([Forms]![PDetail_Form]![Frame_Coupons]=1,([TENDSALE].[TENDER_TYPE])<500,([TENDSALE].[TENDER_TYPE])>=500)
but this returns nothing in the query. Am I missing something?
Thanks Mike
these as the criteria of a query if possiable. The option buttons value's are
1 and 2.
So I thought I could say............In the Criteria of TENDER_TYPE
IIf([Forms]![PDetail_Form]![Frame_Coupons]=1,([TENDSALE].[TENDER_TYPE])<500,([TENDSALE].[TENDER_TYPE])>=500)
but this returns nothing in the query. Am I missing something?
Thanks Mike