A
Archidude
I am trying to fill in multiple control values with a single input. My form
is based on a select query composed of three tables "Budgets", "Requests" and
"tblEqReq" which all have the same field [Proj No]. When I construct the form
I use three controls, two of which will not be visible once I get the form to
work. Temporarily I have left them visible to see how the form works. I have
inserted the expression =[Budgets.Proj No] in the default value for the
invisible controls, however, the form will only display one calculated value.
The second one will not display. I have changed tab positions of the controls
and that doesn't seem to help. Any suggestions?
is based on a select query composed of three tables "Budgets", "Requests" and
"tblEqReq" which all have the same field [Proj No]. When I construct the form
I use three controls, two of which will not be visible once I get the form to
work. Temporarily I have left them visible to see how the form works. I have
inserted the expression =[Budgets.Proj No] in the default value for the
invisible controls, however, the form will only display one calculated value.
The second one will not display. I have changed tab positions of the controls
and that doesn't seem to help. Any suggestions?