Help with sub form combo box

[MNNovice]

Question 1: I have a table called tblAccounts : fields are: AccountID (Auto), AcctNo (Text) and AcctDescr (Text)

In my expese sub form, I am trying to auto populate a text box called txtAcctDescr when I enter the account number in a combo box called cboSEAccount. How do I do this?

Question 2: I have another table called tblEmployees: first 3 fields are: EmployeeID (Auto), EmpLastName (text) & EmpFirstName (text)

In my expense sub form, I have a combo box called cboProjectMgr. Where I would like to display the names as First Name space Last Name. So I created an expression like this: Name: [EmpFirstName]& "" &[EmpLastName].

But I don't get to display the list as such. Nor am I able to select a name to populate the combo box on the sub form called cboProjectMgr.

How do I fix this problem?

Thanks for any help I can get.

Regards.

[ChipR]

For question 1, you could put a line of code in the cboSEAccount AfterUpdate event to set the txtAcctDescr.
For question 2, make a query based on tblEmployees with the employeeID and Name:[...] fields. Set the cboProjectMgr to store the (hidden) EmployeeID and display the Name column.

[NeoPa]

What's the Record Source for the ComboBox (cboProjectMgr) M?

Also, if it has multiple columns, which is the bound one?

[MNNovice]

NeoPa:

The record source for cboProjectMgr is tblEmployees. EmployeeID is the bound column.

I would like it to look up EmployeeID and then populate txtProjectMgr as for example, John (EmpFirstName) Smith (EmpLastName).

Thanks.

[MNNovice]

ChipR:

Thanks for your suggestions. Unfortunately I am not an expert in SQL and wouldn't know how to set the txtAcctDescr. Can you be a little for specific and/or detailed in your suggestion?

I will try the query option you mentioned. Shall keep you posted.

Many Thanks.

[NeoPa]

@MNNovice
You should be able to use the .Column() property of the ComboBox (to refer idividually to the various fields in the table), or use DLookup() for each field separately (using the ID returned). I would suggest the .Column approach is far superior.

[ChipR]

You can go to the cboSEAccount combo box's Properties. On the Event tab, for After Update choose Code Builder. In that function you can add a line like:

txtAccountDescr = (whatever you want)

That should be all you need and it will happen whenever a value is chosen from the combo box.