Saving form field with expression back to table

[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

 

[NetworkTrade]

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

 

[Jo]

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

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

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

 

[NetworkTrade]

Me.[Eng Hours]=Me.[Eng Hours UB]


--
NTC

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

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

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