R
RasberryStolli
I have a data access page based off a parameter query. The parameter
prompts the user to enter an IP Address. If the IP Address is in the
table it will show the IP Address and description. If the IP Address
is not in the table I want to display a message "not in use". I have
tried using scripts in the Microsoft script editor but have had no
luck. I have successfully done this in a form by using an expression
IIF(IsNull([IP Address]), " not in use", [IP Address]) as the control
source. This works in the form but will not work in the DAP. Does
anyone have a solution. If it entails using the Microsoft Script
Editor please be detailed in describing where exactly to insert the
script. I have tried inserting before update, after update, data page
complete and onclick. Nothing has worked yet.
Thanks
prompts the user to enter an IP Address. If the IP Address is in the
table it will show the IP Address and description. If the IP Address
is not in the table I want to display a message "not in use". I have
tried using scripts in the Microsoft script editor but have had no
luck. I have successfully done this in a form by using an expression
IIF(IsNull([IP Address]), " not in use", [IP Address]) as the control
source. This works in the form but will not work in the DAP. Does
anyone have a solution. If it entails using the Microsoft Script
Editor please be detailed in describing where exactly to insert the
script. I have tried inserting before update, after update, data page
complete and onclick. Nothing has worked yet.
Thanks