Seating Chart Report

[Kidnut]

I have an image of our office layout in a report. The idea being I would
place text fields on the report with names that correspond to locations.
D-1, D-2 etc.
Then in the employee table under the location field I see a value of D-1 so
I know to put the person's name and extension in the text box to show on the
report.

In my report code I open up a recordset of employees and I read through it.
I assign the location value to a variable. I now want to use that variable
and see if a text box exists who's name is equal to the value of the
variable. I don't know how to do that.

 

[Jim Burke in Novi]

When you say 'see if a text box exists who's name is equal to the value of the
variable', I'm assuming you mean that, for example, the textbox is called D1
and it has a person's name stored in it. If that's the case, reference the
textbox using

Me.Controls(variable).Value

where 'variable' represents the variable containing the name of the textbox.

 

[Kidnut]

Thanks,

You got me on track to this

Me.Controls(v_txtbox).ControlSource = "='" & v_data & "'"