Command Buttons

Al:

Does the Me in Me.Other = Me.FirstName equal the Table Name?

"Al Camp" wrote:

Jim,
If a text control, on a form, is "bound" to a field in your table, any
data entered into that text control will be stored in that field of your
table.
"Bound" means that the ControlSource property of that text control is set
to the appropriate field name from your table
If that value must be passed to another control on the form, and saved in
the table, then that second field must be bound also.
Say you had a field called FirstName, bound to [FirstName] in your
table... and another field on the form called Other, bound to field [Other]
in your table.
In order to pass that value from FirstName to Other, use the AfterUpdate
event of FirstName with this code...
Me.Other = Me.FirstName

A text control must be bound to a field in your table (ControlSource) in
order to save the value entered into it.
A text control with a (ControlSource) calculation such as =FirstName will
display the FirstName value, but will not store it.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
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??

Jim.
I think Fred G understood better than I what you were trying to do.
Did you read his response?
"jimswinder" wrote in message
...
Al:

Does the Me in Me.Other = Me.FirstName equal the Table Name?

"Al Camp" wrote:

Jim,
If a text control, on a form, is "bound" to a field in your table, any
data entered into that text control will be stored in that field of your
table.
"Bound" means that the ControlSource property of that text control is
set
to the appropriate field name from your table
If that value must be passed to another control on the form, and saved
in
the table, then that second field must be bound also.
Say you had a field called FirstName, bound to [FirstName] in your
table... and another field on the form called Other, bound to field
[Other]
in your table.
In order to pass that value from FirstName to Other, use the
AfterUpdate
event of FirstName with this code...
Me.Other = Me.FirstName

A text control must be bound to a field in your table (ControlSource)
in
order to save the value entered into it.
A text control with a (ControlSource) calculation such as =FirstName
will
display the FirstName value, but will not store it.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
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??

Fred is demonstrating how to concatenate 4 fields (your example) into one
field... but for display ONLY.
= [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4]
Since all 4 fields are bound, and saved in the table, there's no need to
save the "I see red spots". You can always reconcatenate them again
later... in any subsequent form or report or query.

In another example, if you saved [Price] and [Qty] you wouldn't have to save
the Cost (=Price*Qty). You would just place an unbound field on your form
with =[Price]*[Qty] and it will always display the correct Cost.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
Al:

Does the Me in Me.Other = Me.FirstName equal the Table Name?

"Al Camp" wrote:

Jim,
If a text control, on a form, is "bound" to a field in your table, any
data entered into that text control will be stored in that field of your
table.
"Bound" means that the ControlSource property of that text control is
set
to the appropriate field name from your table
If that value must be passed to another control on the form, and saved
in
the table, then that second field must be bound also.
Say you had a field called FirstName, bound to [FirstName] in your
table... and another field on the form called Other, bound to field
[Other]
in your table.
In order to pass that value from FirstName to Other, use the
AfterUpdate
event of FirstName with this code...
Me.Other = Me.FirstName

A text control must be bound to a field in your table (ControlSource)
in
order to save the value entered into it.
A text control with a (ControlSource) calculation such as =FirstName
will
display the FirstName value, but will not store it.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
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??

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 a key word. I thought
it would be easier to have the query look in one field rather than up to 340
different fileds. Suggestions?


"Al Camp" wrote:

Fred is demonstrating how to concatenate 4 fields (your example) into one
field... but for display ONLY.
= [Field1] & " " & [Field2] & " " & [Field3] & " " & [Field4]
Since all 4 fields are bound, and saved in the table, there's no need to
save the "I see red spots". You can always reconcatenate them again
later... in any subsequent form or report or query.

In another example, if you saved [Price] and [Qty] you wouldn't have to save
the Cost (=Price*Qty). You would just place an unbound field on your form
with =[Price]*[Qty] and it will always display the correct Cost.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
Al:

Does the Me in Me.Other = Me.FirstName equal the Table Name?

"Al Camp" wrote:

Jim,
If a text control, on a form, is "bound" to a field in your table, any
data entered into that text control will be stored in that field of your
table.
"Bound" means that the ControlSource property of that text control is
set
to the appropriate field name from your table
If that value must be passed to another control on the form, and saved
in
the table, then that second field must be bound also.
Say you had a field called FirstName, bound to [FirstName] in your
table... and another field on the form called Other, bound to field
[Other]
in your table.
In order to pass that value from FirstName to Other, use the
AfterUpdate
event of FirstName with this code...
Me.Other = Me.FirstName

A text control must be bound to a field in your table (ControlSource)
in
order to save the value entered into it.
A text control with a (ControlSource) calculation such as =FirstName
will
display the FirstName value, but will not store it.

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"jimswinder" wrote in message
...
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??