Forms & Subforms

[Pam]

I’m making a Reapirs Tracking Database for someone. On the Repair Entry Form
I have two sub forms (not visible)
1. Client Contact Subform
2. Agent Contact Subform
So that when a Client or Agent Contact Person is chosen from a drop down
(combo box) the fields below with “Tel No†,“Fax Noâ€, “Email†are
automatically updated with the relevant information.
This is working fine except that on a “new†record, the fields where the
Agent information fields, “Tel No†etc. should be blank, it shows #Error, but
not so where the Client information is.
In both sections of the form I have put the same expression in the control
source
=[Repairs Client Contact Subform]![CLCP Tel No]
=[Repairs Agent Contact Subform]![AGCP Tel No]
I have also tried it with the whole string something along the lines of
=Forms![Form Name]![Subform]!Form[Subform Name],[Field]; (I’m not sure
exactly but I copied them from answers to other people’s questions). This
returns a NAME?? error
My 1st scenario works for the Client fields, but not the Agent fields.
However once the information in the drop down has been entered the #Error
message disappears and the information updates.
So whatever I’ve done works, but WHY the #Error message on a new record for
data realting to the one sub form and not the other?

 

[Ken Snell [MVP]]

Because initially there is no record in the subform for the control to read
and obtain the value; hence, the error. After you select an agent, a record
is produced in the subform, and the control has something to read. Try using
this as the Control Source:

=IIF(IsError([Repairs Agent Contact Subform]![AGCP Tel No]),Null,[Repairs
Agent Contact Subform]![AGCP Tel No])

 

[Pam]

THANKS so much, works great!!!

Because initially there is no record in the subform for the control to read
and obtain the value; hence, the error. After you select an agent, a record
is produced in the subform, and the control has something to read. Try using
this as the Control Source:

=IIF(IsError([Repairs Agent Contact Subform]![AGCP Tel No]),Null,[Repairs
Agent Contact Subform]![AGCP Tel No])
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

I'm making a Reapirs Tracking Database for someone. On the Repair Entry
Form
I have two sub forms (not visible)
1. Client Contact Subform
2. Agent Contact Subform
So that when a Client or Agent Contact Person is chosen from a drop down
(combo box) the fields below with "Tel No" ,"Fax No", "Email" are
automatically updated with the relevant information.
This is working fine except that on a "new" record, the fields where the
Agent information fields, "Tel No" etc. should be blank, it shows #Error,
but
not so where the Client information is.
In both sections of the form I have put the same expression in the control
source
=[Repairs Client Contact Subform]![CLCP Tel No]
=[Repairs Agent Contact Subform]![AGCP Tel No]
I have also tried it with the whole string something along the lines of
=Forms![Form Name]![Subform]!Form[Subform Name],[Field]; (I'm not sure
exactly but I copied them from answers to other people's questions). This
returns a NAME?? error
My 1st scenario works for the Client fields, but not the Agent fields.
However once the information in the drop down has been entered the #Error
message disappears and the information updates.
So whatever I've done works, but WHY the #Error message on a new record
for
data realting to the one sub form and not the other?