Saving form field with expression back to table

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

I have developed a form (A) from table (B). I needed to bring info into some
of these fields from a query so I used =DLookUp in the Control Source. Also,
I used calculation expressions in the control source for other fields
(=[field]*[filed2]). In order to do this the initial table field name was
removed from the Control Source. Now, when I save the form it will not
populate these fields back in the original table.

I am a basic Access 2007 user level and could really use some advice here.
Thanks,
JoSinai
 
well you unbound the form from its original source and that is why....

in general terms; all the stuff that you've successfully done i.e. lookups,
calculated expressions...etc Do all of this with new, unbound text boxes
added to your form...

change the form back to its original source with all the original fields....

at an appropriate event (user tab or after update or onFormat) then use vba
to update the bound fields with the values from the unbound fields
 
Thank you, I understand what you are saying.

Could you please help me with the vba code to update the bound fields with
the values from the unbound fields.

Example: User Tab - update field "Eng Hours" with unbound field "Eng Hours
UB"

How would I code this?

Many thanks

--
JoSinai


NetworkTrade said:
well you unbound the form from its original source and that is why....

in general terms; all the stuff that you've successfully done i.e. lookups,
calculated expressions...etc Do all of this with new, unbound text boxes
added to your form...

change the form back to its original source with all the original fields....

at an appropriate event (user tab or after update or onFormat) then use vba
to update the bound fields with the values from the unbound fields
--
NTC


Jo said:
I have developed a form (A) from table (B). I needed to bring info into some
of these fields from a query so I used =DLookUp in the Control Source. Also,
I used calculation expressions in the control source for other fields
(=[field]*[filed2]). In order to do this the initial table field name was
removed from the Control Source. Now, when I save the form it will not
populate these fields back in the original table.

I am a basic Access 2007 user level and could really use some advice here.
Thanks,
JoSinai
Click to expand...
Click to expand...
 
Me.[Eng Hours]=Me.[Eng Hours UB]


--
NTC


Jo said:
Thank you, I understand what you are saying.

Could you please help me with the vba code to update the bound fields with
the values from the unbound fields.

Example: User Tab - update field "Eng Hours" with unbound field "Eng Hours
UB"

How would I code this?

Many thanks

--
JoSinai


NetworkTrade said:
well you unbound the form from its original source and that is why....

in general terms; all the stuff that you've successfully done i.e. lookups,
calculated expressions...etc Do all of this with new, unbound text boxes
added to your form...

change the form back to its original source with all the original fields....

at an appropriate event (user tab or after update or onFormat) then use vba
to update the bound fields with the values from the unbound fields
--
NTC


Jo said:
I have developed a form (A) from table (B). I needed to bring info into some
of these fields from a query so I used =DLookUp in the Control Source. Also,
I used calculation expressions in the control source for other fields
(=[field]*[filed2]). In order to do this the initial table field name was
removed from the Control Source. Now, when I save the form it will not
populate these fields back in the original table.

I am a basic Access 2007 user level and could really use some advice here.
Thanks,
JoSinai
Click to expand...
Click to expand...
Click to expand...
 
Back
Top