Merge two controls into one, please help

[marcosedh]

Im a self-taught access user so I don't know much about terms or tricky stuff..



Im desperate to find a way to merge two controls into one, for example:

I have this 2 controls: First Name & Last Name.

I want to create one expression off those two controls named "Student Name".


--- using =[First name]&" "&[Last Name] won't work for my purpose ---

Thank you very much and have a nice day

[RuralGuy]

What kind of controls and why won't the concatenation work?

[marcosedh]

What kind of controls and why won't the concatenation work?

It won't work because I created a sub form with a "create report button" and whenever I create the report, it will display the current student name in such report with the data of all students combined. So I want to create a page in that report for each student. Hope I explained myself, english is not my native language heh

[RuralGuy]

What code/macro is behind the "create report button"?

[marcosedh]

I used the create report wizard

[marcosedh]

Private Sub Command54_Click()
On Error GoTo Err_Command54_Click


Dim stDocName As String


stDocName = "Observaciones"
DoCmd.OpenReport stDocName, acPreview


Exit_Command54_Click:
Exit Sub

[RuralGuy]

What is the Record Source of the Report? Can you post the SQL for the Record Source of that Report?

[marcosedh]

The record source is a simple table, so I think there's no SQL, that means I have to create a query for it to work?

[RuralGuy]

You can also use the WHERE CONDITION argument of the OpenReport command to filter the Report. You said the Button is on the SubForm. Is there a value in the Record Source of the SubForm Record that can be used to filter the Report?

[marcosedh]

You can also use the WHERE CONDITION argument of the OpenReport command to filter the Report. You said the Button is on the SubForm. Is there a value in the Record Source of the SubForm Record that can be used to filter the Report?

Yes, every entry has its own ID. How can I use the where condition argument to filter by id?

[RuralGuy]

Here's the syntax of the OpenReport Command:
DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)


WhereCondition Optional Variant. A string expression that's a valid SQL WHERE clause without the word WHERE.

[RuralGuy]

This link has examples of how to use the WHERE CONDITION argument. It uses OpenForm but the syntax is the same for OpenReport.
http://www.baldyweb.com/wherecondition.htm

[marcosedh]

Im trying these = DoCmd.OpenReport([observaciones], [ViewsAllowed], [Filter], Var([ID], [PopUp], [OpenArgs]) but i get this message:

"The expression you entered has a function containing the wrong number of arguments."

[RuralGuy]

Try: DoCmd.OpenReport observaciones, , ,"[ID] = " & [ID]

[marcosedh]

"The expression you entered contains invalid syntax"

= DoCmd.OpenReport([observaciones], [ViewsAllowed], [Filter], Var([ID] = & [ID], [PopUp], [OpenArgs])
Attachment 26295