Textbox on Mainform showing selected data on subform

B

BZeyger

I have a form that contains numerous subforms. On the main form (in the
detail section), I have a textbox that is supposed to retrieve the
information I have selected in the subform.

The subform has a listing of all employees in the detail section. The user
would click on the desired employee and the information would change based on
which employee is selected from the detail section of the drop down.

I would like to have the employee selected from the subform appear in a text
box on the main form. Every time I do this I get a #Name? error on the text
box.

Main Form – frmMain
Subform1 - subEmpHours
Textbox on subform that contains data – (txtEmp (in the detail section) and
txtEmpSel (in the footer section of subfrom)…contains same info)
Textbox on main form – txtEmpHours

I have inputed this in the textbox on the main form
=([Subform1].[Form]![txtEmpSel])

I can I get this to work?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top