open form from a form with matching ID numbers and update table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data entry form with a command button to open another form to enter
comments. The form opens as I programmed it with the matching customer ID;
however the form is not updating my underlying table, though it updates the
other keyed in info. What am I doing wrong???

Thanks.

Trac
 
In looking at your question - the part I do not understand is this:

"...the form is not updating my underlying table, though it updates the
other keyed in info..."
Click to expand...

Perhaps others will understand...but to me this appears contradictory...can
you explain what the 'other keyed in info' is if it is not to the same record
source as the comments
 
Sorry I wasn't clear. I have other fields on the form that require data
entry. The fields that were entered manually update to the table; however,
the field that is linked does not update in the table. The text box data
source in the second form reads: =Forms![frmCustomer Satisfaction
Survey]!Combo0. Combo0 is the name of the combo box in the first form where
the user selects their desired customer number. Thanks for your help.

Tracy
 
Hi -

The data source (do you mean control source?) in the text box must be
the name of the table field that you want the data to be saved to. Try
putting =Forms![frmCustomer Satisfaction Survey]!Combo0 as the default
value for the text box.

John

Sorry I wasn't clear. I have other fields on the form that require data
entry. The fields that were entered manually update to the table; however,
the field that is linked does not update in the table. The text box data
source in the second form reads: =Forms![frmCustomer Satisfaction
Survey]!Combo0. Combo0 is the name of the combo box in the first form where
the user selects their desired customer number. Thanks for your help.

Tracy

:

In looking at your question - the part I do not understand is this:

"...the form is not updating my underlying table, though it updates the


Perhaps others will understand...but to me this appears contradictory...can
you explain what the 'other keyed in info' is if it is not to the same record
source as the comments
--
NTC


:
Click to expand...
Click to expand...
 
Back
Top