name error on subform (1 Viewer)

p4nny

New member
Local time
Today, 12:14
Joined
Mar 16, 2020
Messages
15
Hello

I have a form containing controls (combo, textbox) and a also a subform.

Everything works fine. Only issue is, the subform shows #name error on load in each field.

Combo box connects to subform using vba as a filter (Afterevent)

Would appreciate any help or guidance

Many thanks
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:14
Joined
May 7, 2009
Messages
19,175
maybe you use different fieldname in the textbox of subform rather than the correct one.
if not bound, what is the controlsource of each textbox?
 

vba_php

Forum Troll
Local time
Today, 07:14
Joined
Oct 6, 2019
Messages
2,884
furthermore, what is the value in the "recordsource" property of the subform? that might cause the error as well, considering the error is happening in every single control on the sub. that indicates a big picture problem, not a piecemeal problem.
 

moke123

AWF VIP
Local time
Today, 08:14
Joined
Jan 11, 2013
Messages
3,852
Have you tried setting the recordsource of your subform in the load event of the main form? I believe a subform loads first so if it depends on value of the combo for instance it is not available. Are there link Master/child fields involved?
 

p4nny

New member
Local time
Today, 12:14
Joined
Mar 16, 2020
Messages
15
Thanks for these tips. Now resolved!
 

Users who are viewing this thread

Top Bottom