I have a form that has 3 tabs. ON each tab, there are at least 2 subforms. ON the main form, I have a combo box for getting the inspectors name.
What I am trying to do is take the inspector name from the combo box and put it in the first field in each subform (to make sure that the correct inspector is getting credit for the work)
On the first tab, it shows up in one subform but I get an error message saying it can't find hte field on the second form. I have checked the form for spelling errors etc but all looks well.
CAn someone see what I'm doing wrong??
the code I'm using is
The lines that are commented out are the ones that are not working.
Thanks for any help.
lhuffst
What I am trying to do is take the inspector name from the combo box and put it in the first field in each subform (to make sure that the correct inspector is getting credit for the work)
On the first tab, it shows up in one subform but I get an error message saying it can't find hte field on the second form. I have checked the form for spelling errors etc but all looks well.
CAn someone see what I'm doing wrong??
the code I'm using is
Code:
txtmainwsscid = Me.cboLookUp.Column(3)
'make sure person logged in or selected in drop down box is passed
Me!frmReports.Form!Txtcboselected = Me!cboLookUp.Value
Me!frmSbDataEntry.Form!EmployeeName = Me!cboLookUp.Value
'Me!frmSbEquipRprTstBench.Form!EmployeeName = Me!cboLookUp.Value
'Me!frmSbFHMetersRepaired.Form!EmployeeName = Me!cboLookUp.Value
'Me!frmSbMeterTestingResults.Form!EmployeeName = Me!cboLookUp.Value
'Me!FrmSbLrgMetersIssued.Form!EmployeeName = Me!cboLookUp.Value
'Me!frmSbMeterCrates.Form!EmployeeName = Me!cboLookUp.Value
Me!FrmSbMetersInStock.Form!EmployeeName = Me!cboLookUp.Value
'Me!frmSbScrappedMeters.Form!EmployeeName = Me!cboLookUp.Value
The lines that are commented out are the ones that are not working.
Thanks for any help.
lhuffst