Ok I think this problem is just a matter of syntax.
I'm trying to fill in a text box with fields from a recordset.
If I were just typing what I wanted into the
Data/control source field it would look like this:

= "Transacciones correspondiendo al recipiente: " & rst!FirstName.value & " " & rst!LastName.Value

so I put it into the format section of report header like this

Me.txtTitle = = "Transacciones correspondiendo al recipiente: " & rst!FirstName.value & " " & rst!LastName.Value

It's obvious that the quotes are messing things up, but I've tried a number of ideas and I can't figure out how the quotes should be. Also both first and last name are strings so I think I need the other quotes to typecast them.

Thanks for your help


Enoch

__________________
Enoch

Ok well, I feel kind of silly, but I realized I should be using
the controlsource property rather than the value property. I think I can figure out how the quotes work
sorry to waste time.


Enoch

Just in case anyone is interested, here's a working answer to my question.

First off, it turns out you can't assign the controlsource property in a format event. So I placed it in the open event

    Me!txtTitle.ControlSource = "= 'Donaciones al Beneficiario: " & _
       rst!FirstName & " " & rst!LastName & "'"

You don't need to typecast the rst fields because it's already within the quotes. I think I could actually change this to a label.


Enoch