Calling Field Values from another form to a text box on a separate form

[mindbender]

I have a login for that is a drop down where the users select their name and a password box.


The drop down on the Logon_Form is driven by the row source of

SELECT TblEmployees.XeroxCanada_EmpNo, [VSE_FirstName] & ' ' & [VSE_Surname_Name] AS Fullname, TblEmployees.strEmpPassword, TblEmployees.PWReset, TblEmployees.accesslevel_id, TblEmployees.Mgr_EmpNo, TblEmployees.OpsMgr_EmpNo FROM TblEmployees ORDER BY TblEmployees.VSE_FirstName, TblEmployees.VSE_Surname_Name;

On the main form I am using the default value to auto populate ids on the creation of a new record.
The User's id (XeroxCanada_EmpNo) is captured by

=[Forms]![Logon_Form]![cboUser].[Column](0)

and this works as expected
The Users manager's id (iMgr_EmpNo) s captured by

=[Forms]![Logon_Form]![cboUser].[Column](5)

and this works as expected
The Manager's Manager id (OpsMgr_EmpNo) is captured by

=[Forms]![Logon_Form]![cboUser].[Column](6)

and this does not return the value.

When I run the initial query used by the Logon_Form with the User's name I am testing with all the ids return as expected.

Is there a limit to the number of columns or something I am missing as to why I can put any number 5 or less and return the expected value but once I enter 6 it returns blank?

Thanks as always for the assistance

[ranman256]

You cannot use .columns in a query.
you CAN put another textbox on the form, fill it with the column value after user picks it.
then use THAT textbox in the query.

sub cboBox_afterupdate()
  TxtBoxCity = cboBox.column(2)
end sub

[mindbender]

I am not sure I understand. Why would what I have work fine for Columns 0-5 but not for column 6?

[mindbender]

I figured it out. The default value for column count is 5. Once I changed it to 6 the 6th column is now coming through