- Joined
- Jul 12, 2007
- Messages
- 45
- Reaction score
- 0
Greetings Databasers! 
Please help. How do I get this to work. I have a stand alone form and trying to use an unbound text box to display information when the IIF statement is met. All the form shows is this +Name?
The fields are found in a query, what am I doing wrong?
IIF ([Query].[Schedule Query].[SchedDateTime]="Mon9-11".[Schedule Query].[CustomerFirstName] & " " & [Schedule Query].[CustomerLastName] & "<BR>" & [Schedule Query].[Address] & "<BR>" & [Schedule Query].[City] & " " & [Schedule Query].[State])
Please help. How do I get this to work. I have a stand alone form and trying to use an unbound text box to display information when the IIF statement is met. All the form shows is this +Name?
The fields are found in a query, what am I doing wrong?
IIF ([Query].[Schedule Query].[SchedDateTime]="Mon9-11".[Schedule Query].[CustomerFirstName] & " " & [Schedule Query].[CustomerLastName] & "<BR>" & [Schedule Query].[Address] & "<BR>" & [Schedule Query].[City] & " " & [Schedule Query].[State])