form [control] failure

[Guest]

formA contains auto-sequenced number from tableA...formB of tableB populates
a textbox/control using 'source control' (=[Forms]![Call Survey Form]![Survey
Call Number]) from formA. The number pulls in ok, but on entry does not save
to tableB. Am exhausted form trying a lot options that aren't working. Would
gladly take some help...Thx.

 

[John Vinson]

formA contains auto-sequenced number from tableA...formB of tableB populates
a textbox/control using 'source control' (=[Forms]![Call Survey Form]![Survey
Call Number]) from formA. The number pulls in ok, but on entry does not save
to tableB. Am exhausted form trying a lot options that aren't working. Would
gladly take some help...Thx.

A textbox (or other control) can be bound to a table field, or to an
expression - but not both.

Setting the Control Source to your Forms! expression *displays* that
value on the form, but will not (and should not!!) store that
displayed value in your table.

Might it not be better to use FormB as a Subform on FormA, using the
Survey Call Number as the master/child link field? If not, you will
need to use VBA code to pass the value. What's the Recordsource of
FormB, and what are you trying to accomplish with the call number?

John W. Vinson[MVP]

 

[Guest]

trying to save fellow emps some keystokes. will try the sub-form. appreciate
your input on the binding of controls. i'm not smart enuff to know when to
quit and would have been at it 'til it gave in or i fell over.
thanks again.
--
zzzzzzz!

formA contains auto-sequenced number from tableA...formB of tableB populates
a textbox/control using 'source control' (=[Forms]![Call Survey Form]![Survey
Call Number]) from formA. The number pulls in ok, but on entry does not save
to tableB. Am exhausted form trying a lot options that aren't working. Would
gladly take some help...Thx.

A textbox (or other control) can be bound to a table field, or to an
expression - but not both.

Setting the Control Source to your Forms! expression *displays* that
value on the form, but will not (and should not!!) store that
displayed value in your table.

Might it not be better to use FormB as a Subform on FormA, using the
Survey Call Number as the master/child link field? If not, you will
need to use VBA code to pass the value. What's the Recordsource of
FormB, and what are you trying to accomplish with the call number?

John W. Vinson[MVP]

 

[John Vinson]

trying to save fellow emps some keystokes.

Good on ya!

will try the sub-form

That's a good way to do so!

John W. Vinson[MVP]