Command Buttons

On Wed, 24 Aug 2005 11:47:10 -0700, jimswinder wrote:

Perhaps I should back up a step...
lets say I have 4 fields (all text fields). Field 1 has "I", Field 2 has
"see", Field 3 "red" and Field 4 "spots." What I want to do is combine the
four fields and put the combined text "I see red spots" into a fifh field in
the table. I have no problem combining the fields within a form...but can't
get the new text into the fifth table field.

PS..thanks for fast response!!!! :-)

"Ronald Roberts" wrote:

jimswinder wrote:

I am trying to create a button that when clicked will take text from a field
in a form and put it into a field in the table from where the form was
created. Is this possible?
I have tried using the Expression Builder (=[Combo51] = [Combo42] )...but
the text does not get into the table field. Thoughts??


Not sure I understand what you want.
If the form is bound, which means the form has a record source.
And if the controls on the form are bound, which means they have a
control source, then the table will be updated when the user moves to
another record or closes the form.

If you are trying to update a calculated field, don't.
This will lead to other data problems in the future. All calculated
fields or values can be recalculated in a form in an unbound control
or in a query for a report.

Ron



You shouln't save that calculated field.
As Control source of an UNBOUND control on a form or report:

= [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4]

There is no need to store this result!!!!

As long as you have the other fields data saved, any time you need to
see the combined text, combine them, as above, in a query, form or
report.



--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

I know I shouldn't save the result...but is ther any way I can?
Here is the ultimate problem (at least for me). I have 34 different tables
all with differing fields that contain descriptions of parts. I need to run a
query that will look at EVERY Field in EVERY Table for one key word. I
thought
it would be easier to have the query look in one field rather than up to 340
different fileds. Suggestions?



"fredg" wrote:

On Wed, 24 Aug 2005 11:47:10 -0700, jimswinder wrote:

Perhaps I should back up a step...
lets say I have 4 fields (all text fields). Field 1 has "I", Field 2 has
"see", Field 3 "red" and Field 4 "spots." What I want to do is combine the
four fields and put the combined text "I see red spots" into a fifh field in
the table. I have no problem combining the fields within a form...but can't
get the new text into the fifth table field.

PS..thanks for fast response!!!! :-)

"Ronald Roberts" wrote:

jimswinder wrote:

I am trying to create a button that when clicked will take text from a field
in a form and put it into a field in the table from where the form was
created. Is this possible?
I have tried using the Expression Builder (=[Combo51] = [Combo42] )...but
the text does not get into the table field. Thoughts??


Not sure I understand what you want.
If the form is bound, which means the form has a record source.
And if the controls on the form are bound, which means they have a
control source, then the table will be updated when the user moves to
another record or closes the form.

If you are trying to update a calculated field, don't.
This will lead to other data problems in the future. All calculated
fields or values can be recalculated in a form in an unbound control
or in a query for a report.

Ron



You shouln't save that calculated field.
As Control source of an UNBOUND control on a form or report:

= [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4]

There is no need to store this result!!!!

As long as you have the other fields data saved, any time you need to
see the combined text, combine them, as above, in a query, form or
report.



--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

PS...I tried running a query on all of the fields and got an error "Too
Complex..." that's when I went down the path of trying to get the fields into
one field.

"fredg" wrote:

On Wed, 24 Aug 2005 11:47:10 -0700, jimswinder wrote:

Perhaps I should back up a step...
lets say I have 4 fields (all text fields). Field 1 has "I", Field 2 has
"see", Field 3 "red" and Field 4 "spots." What I want to do is combine the
four fields and put the combined text "I see red spots" into a fifh field in
the table. I have no problem combining the fields within a form...but can't
get the new text into the fifth table field.

PS..thanks for fast response!!!! :-)

"Ronald Roberts" wrote:

jimswinder wrote:

I am trying to create a button that when clicked will take text from a field
in a form and put it into a field in the table from where the form was
created. Is this possible?
I have tried using the Expression Builder (=[Combo51] = [Combo42] )...but
the text does not get into the table field. Thoughts??


Not sure I understand what you want.
If the form is bound, which means the form has a record source.
And if the controls on the form are bound, which means they have a
control source, then the table will be updated when the user moves to
another record or closes the form.

If you are trying to update a calculated field, don't.
This will lead to other data problems in the future. All calculated
fields or values can be recalculated in a form in an unbound control
or in a query for a report.

Ron



You shouln't save that calculated field.
As Control source of an UNBOUND control on a form or report:

= [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4]

There is no need to store this result!!!!

As long as you have the other fields data saved, any time you need to
see the combined text, combine them, as above, in a query, form or
report.



--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.