Chime Error?

[bytreeide]

That sounds like a better method than what I have been doing. Do you have a link that explains how to do this?

Also I tried changing the ControlSource of the controls, but I got error: #Name?

So I have "T4EmployeeID_Combo" which is a combo box and the "RowSource" is set to a QUERY "Q1EntryUser" which has the following fields:

UserID
T1EmployeeFirstName
T1EmployeeLastName
Q1EmployeeFullName: [T1EmployeeFirstName] & " " & [T1EmployeeLastName]
T1EmployeeEmail
T1EmployeeNumber
T1EmployeeExtension



On FORM F4CBA I have three text boxes that I want to fill and used the following as the ControlSource

F4EmployeeName = [Q1EntryUser]![Q1EmployeeFullName]
T4EmpEmail = [Q1EntryUser]![T1EmployeeEmail]
T4EmpNum = [Q1EntryUser]![T1EmployeeNumber]

I really thought this would work, but I still get #Name?.

Suggestions?

bytreeide

[June7]

No specific link. Search Access Help or web.

Review example in post 9.

[bytreeide]

Thanks for the help again. My one problem with making the combo boxes work the way that you suggested the first time is that I have gotten used to access limiting my choices or predicting the outcome of what I was typing. I was have been so used to the word "Column" appear as one of the options in the expression builder or VBA code editor once I have typed "C" and "O". In this case I did not receive a prompting, so then thought that this would be wrong and wouldn't work. Glad to know that this works. Learning that not every option is listed in the expression values has sort of shattered my trust in Access. I thought it was right all the time and only gave the possible options based on what I have entered.

I am going to suppose that it would be wise (and that you would recommend) of me to go through my other FORMs and make these changes to the combo boxes and text boxes.

Thanks for all the help I will do some research on conditional formatting.

I consider this issue solved.

bytreeide