Seating Chart Report

  • Thread starter Thread starter Kidnut
  • Start date Start date
K

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.
 
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.
 
Thanks,

You got me on track to this

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