Problem with field data....

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a form that uses a drop down box to select the system.
Here is the code for that box (it works perfect)
SELECT [qurEupipEmp].[IDTag], [qurEupipEmp].[FullName],
[qurEupipEmp].[LocationDesc] FROM qurEupipEmp ORDER BY [LocationDesc];

Now the issue is...I want it auto fill the User Name and Location in after
you select the system...the Location Description works however I either get
Name? or nothing in the FullName field.
 
I have a form that uses a drop down box to select the system.
Here is the code for that box (it works perfect)
SELECT [qurEupipEmp].[IDTag], [qurEupipEmp].[FullName],
[qurEupipEmp].[LocationDesc] FROM qurEupipEmp ORDER BY [LocationDesc];

Now the issue is...I want it auto fill the User Name and Location in after
you select the system...the Location Description works however I either get
Name? or nothing in the FullName field.
Click to expand...

Michelle,
Just a quess as I don't know how your assigning the value to your User
Name txt field on your form. If you make the control source of the
User Name txt field =[YourComboBox].[Column](1)
Is should show the FullName you selected from your ComboBox.
If you need further help post more info.

Rick
 
Back
Top