Good afternoon, I am having trouble with a combo box changing the name to the ID instead of displaying the change in name.
2 Tables with a one to many relationship
1. tblClient_MSA that includes Client_MSAID and ClientName
2. tblSOW with SOWID and Client_MSAID
I created a form from the tblSOW that I want display the name of the Client_MSA. Form includes Client_MSAID (textbox), SOWID (textbox) and ClientName (as combo box to change the MSA associated with the SOW if needed). When I change the selection of the combo box from one name to another, it changes the name to the MSAID in both tables. But, as expected, if I changed the ClientMSAID in the form query, then it appropriately changes the name in the qry and in the tables
Information:
Form:
RecordSource: SELECT tblSOW.SOWID, tblSOW.ClientMSAID, tblClient_MSA.ClientName FROM tblClient_MSA INNER JOIN tblSOW ON tblClient_MSA.ClientMSAID = tblSOW.ClientMSAID;
Combo Box:
ControlSource: ClientName
RowSource: SELECT tblClient_MSA.ClientMSAID, tblClient_MSA.ClientName, tblClient_MSA.ClientMSActive
FROM tblClient_MSA
ORDER BY tblClient_MSA.ClientName DESC;
Trouble Shooting completed:
1. There are no hidden relationships.
2. Thought form was corrupt and tried it on a different form.
3. Possible DB corrupt, Imported tables, forms and qry to new database
Very basic. I am stumped. Any help would be greatly appreciated.