can I use IIf , Select in row source
=IIf([Shipping by]="DHL",[Shipping To],SELECT [Shipping To] FROM Shipping; )
can I use IIf , Select in row source
=IIf([Shipping by]="DHL",[Shipping To],SELECT [Shipping To] FROM Shipping; )
Sure, but you can't use the SELECT statement:
=IIf([Shipping by]="DHL",[Shipping To],[SomeOtherField] )