#Error

[Guest]

Hi!

I have a MainForm with a textbox to show us IdPlan in SubForm.
In TextBox ControlSource in MainForm I have:

=[SubF_ProcedPlan].[Form]![IdPlan]

When there are a plan work fine. Show us IdPlan number.
When doesn't show IdPlan (because there aren't plan) the textbox in MainForm
show us #Error.
I would like in this situation show "Hasn't plan" or nothing.

Thanks in advance.
an

 

[Guest]

Try this ---
=IIF([SubF_ProcedPlan].[Form]![IdPlan] Is Null, "Hasn't plan",
[SubF_ProcedPlan].[Form]![IdPlan])

 

[Guest]

Thank you for reply.
Return #Error too.
an

Try this ---
=IIF([SubF_ProcedPlan].[Form]![IdPlan] Is Null, "Hasn't plan",
[SubF_ProcedPlan].[Form]![IdPlan])


--
KARL DEWEY
Build a little - Test a little

Hi!

I have a MainForm with a textbox to show us IdPlan in SubForm.
In TextBox ControlSource in MainForm I have:

=[SubF_ProcedPlan].[Form]![IdPlan]

When there are a plan work fine. Show us IdPlan number.
When doesn't show IdPlan (because there aren't plan) the textbox in MainForm
show us #Error.
I would like in this situation show "Hasn't plan" or nothing.

Thanks in advance.
an

 

[Guest]

Sorry, KD.

Changed TextBox Name to txtIdPlan in SubForm work fine!

Thank you very much for your solution.
an

Try this ---
=IIF([SubF_ProcedPlan].[Form]![IdPlan] Is Null, "Hasn't plan",
[SubF_ProcedPlan].[Form]![IdPlan])


--
KARL DEWEY
Build a little - Test a little

Hi!

I have a MainForm with a textbox to show us IdPlan in SubForm.
In TextBox ControlSource in MainForm I have:

=[SubF_ProcedPlan].[Form]![IdPlan]

When there are a plan work fine. Show us IdPlan number.
When doesn't show IdPlan (because there aren't plan) the textbox in MainForm
show us #Error.
I would like in this situation show "Hasn't plan" or nothing.

Thanks in advance.
an