I have a query criteria combo box to use for choosing a Trip.
All works well except for one condition. I would like cboResTypeID 19 to use the trips
for codes 14 or 16. I get nothing if i use code 19.
IIf([Forms]![frmReservation]![cboResTypeID]=19,([tblTravelMain].[ResTypeID])=14 Or ([tblTravelMain].[ResTypeID])=16,[Forms]![frmReservation]![cboResTypeID])
ResTypeID is a number field.
Thanks you for your help. Glen.
All works well except for one condition. I would like cboResTypeID 19 to use the trips
for codes 14 or 16. I get nothing if i use code 19.
IIf([Forms]![frmReservation]![cboResTypeID]=19,([tblTravelMain].[ResTypeID])=14 Or ([tblTravelMain].[ResTypeID])=16,[Forms]![frmReservation]![cboResTypeID])
ResTypeID is a number field.
Thanks you for your help. Glen.