Command Buttons again

[Guest]

Trying to get a command button to concatenate values in two text boxes and
display it on to a label on the same form.

I have
Private Sub cmdDisplay_Click()
lblFullName.Caption = txtFirst.Text & txtLast.Text
End Sub

I get an error saying the control needs to have the focus, but I have
references to two controls (txtFirst and txtLast).

Is there a fix?

 

[fredg]

Trying to get a command button to concatenate values in two text boxes and
display it on to a label on the same form.

I have
Private Sub cmdDisplay_Click()
lblFullName.Caption = txtFirst.Text & txtLast.Text
End Sub

I get an error saying the control needs to have the focus, but I have
references to two controls (txtFirst and txtLast).

Is there a fix?

In Access, it's a control's Value property you need to use, not it's
text property.
Look them up in VBA help to learn the difference.

Because the Value property is the control's default, you do not need
to state it:

lblFullName.Caption = txtFirst & txtLast

Note: Don't you want a space between the 2 names?
lblFullName.Caption = txtFirst & " " & txtLast