Fill text box with work based on record data (1 Viewer)

[Number11]

So it it possible to have a field on a form that is updated based on what is found within the record source

Like say if field "job type" is Install put in results box "Installed and Complete" or if "job type" is "Refused" put in results box "Installed failed please rebook"

 

[theDBguy]

Sure. You can even do it in the source query.

 

[Number11]

Sure. You can even do it in the source query.

really wow do i go about doing that

 

[jdraw]

You may get some ideas from this article on concatenation.

 

[Number11]

Ok thanks for your help, i have this in the query now and it works but how to i add the other option for if "Refused" put results as "Installed failed"please

Expr1: Replace([Job Type],"Installed","Installed and Complete ")

 

[theDBguy]

Ok thanks for your help, i have this in the query now and it works but how to i add the other option for if "Refused" put results as "Installed failed"please

Expr1: Replace([Job Type],"Installed","Installed and Complete ")

Hi. Maybe check out the Switch() function.