Whats wrong with this code

[colmoore]

Hi all,

Successfully managed to get the following to work:

=[SALUTATION] & " " & [FIRST NAME] & " " & [SURNAME]

But when I try a similar trick with the email and Date of Birth fields it doesn't work. I'm using:

="Email " & [EMAIL ADDRESS]

and

="Date of Birth " & [DATE OF BIRTH]
??????????

 

[WayneRyan]

col,

What does it do? Or not do?

Wayne

 

[colmoore]

Error

Hi there,

I'm just getting #Error where the email address should be.

Any ideas???

 

[Pat Hartman]

You will need to change the Name field of the control to a name different from any names in the form's RecordSource. When the wizard builds a form (or you drop a field from the field list onto the form), Access uses the name of the bound field as the Name property of the control. You have changed the ControlSource to be an expression so the control is no longer bound. That is causing the confusion.

 

[colmoore]

Thanks

Pat,

Thanks so much, your advice has solved the problem

Regards

Col Moore