Combo Box Error: Recordset Not Updatable

[meadows43]

I recently had to alter my database to change the primary key in the Accounts table include the Country as well as the Master Number. A combo box I had on the [Transfer to Other Manager] form that was working fine before now produces the error "Recordset not updatable" when I try to select a different value. The field the combo box is bound to is in an intermediary table [Manager Accounts]. The field contains the [Manager Login]. This table includes the [Master Number] for the account, the [Country] for the account, and the [Manager Login]. This is the SQL for the query that the form is based on

SELECT Accounts.[Account Name], Accounts.Area, Accounts.Country, Managers.[Manager Name], Managers.[Manager Login], Managers.[Sup ID], [Manager Accounts].[Master Number], [Manager Accounts].[Manager Login], [Manager Accounts].[Reports Login], Accounts.[Master Number], [Manager Accounts].Country
FROM (Sups INNER JOIN SAMs ON Sups.[Sup ID] = Managers.[Sup ID]) INNER JOIN (Accounts INNER JOIN [Manager Accounts] ON Accounts.[Master Number] = [Manager Accounts].[Master Number]) ON Managers.[Manager Login] = [Manager Accounts].[Manager Login]
WHERE (((Accounts.Country)=Left([Forms]![Transfer Accounts]![cboAcct],2)) AND (([Manager Accounts].[Master Number])=Right([Forms]![Transfer Accounts]![cboAcct],Len([Forms]![Transfer Accounts]![cboAcct])-2)));

Can anyone help? I've searched the forums and couldn't find anyone else that had this problem with a combo box being caused by a primary key with two fields. The thing that confused me even more is that the primary key that changed is not even in the table the combo box is bound to.

Thanks,

Chris

 

[namliam]

But there is a lot of information available for your original problem (Recordset Not Updatable ) read up on that ....

BR

 

[desibasha]

Form not working

I have a form w/a combo box named Category Name. Category name is a pull down and has a bunch of category names.

What i want the form to do is when the user picks a category name, the rest of the fields get filled automatically, but I am having trouble with this.

Next to Category Name (combo box) i have category description and category ID but the two i guess arnt linked or something b/c nothing happens to category description or category ID when I change the category name.

But I can scroll thru all the records and everything changes.

The information that is supposed to show once a category name is picked doesnt even show. It's in a sub form. But in Form view it's not there.It doesnt show up.

Can someone please explain to me how I can make this form work.

P.S. I have attached pictures of what shows up on the form (untitled) and then what is supposed to be on the form (design view).

 

[desibasha]

whoops

sorry about that.

i was reading urs to get help w/mines and mistakedly put my question as a response to urs.

sorry again!