Updating table data using a Combo box

[browny]

Hi all
I have been nutting out this problem but have been unable to find a solution, even my learned colleague is at a loss to help. This is an data update query using combo boxes and forms.
I have 2 databases, Data and App, I have linked 2 tables, Main and Supervisor from the Data.mdb to the App.mdb. Supervisor has 2 fields ID and Name. Main has multiple fields but is linked to Supervisor by the ID field. I have a query that gets details from the Main Table and this is entered into a form. I deleted the SupervisorID text box and inserted a combo box using the wizard, it gets its data from a query that gets details from the Supervisor table showing the Supervisor name, the ID field in the dropdown is hidden. The combo box selection is held in the SupervisorID of the Main table.
What I want to do is change the Supervisor name using the combo box however I am unable to select another name from the dropdown list.
I have tried changing the Data Entry property of the form to Yes, this did not work. Allow edits is set to yes. I have tried adding another combo box which gets the data straight from the Supervisor table but I have the same problem.
Can anyone help, we think it is a simple property setting but all we have tried has failed to date. Thanks in advance.
Craig

 

[RuralGuy]

It sounds like your form is based on a non-updateable query. Key Troubleshoot Queries into the Access (not VBA) help system.

 

[alexkong2003]

I am having quite a similar problem before.... i had try to using few ways to solving my problem... but it no work. I may share my experience to u see if u r able to solve it. first, u may check is that primary key problem ? u may try to disable and enable the primary key to see it work or not. Second, just put all the entry fields u want to the query table to create your form maybe it work. and my last suggestion is just copy all the field from the form (just field but not with the table) and paste to another new form and run it see it work or not, if work u may check what is the different of the table property by the new and the old one. I hope my suggestion may help u buddy. Then i also need your help~~ u may review the Thread that i post to this forum.

http://www.access-programmers.co.uk/forums/showthread.php?t=113887

I wish u may just give me a hand, Thanksss alot ~~~~

 

[browny]

Hi all
Thanks RuralGuy, trialling the fixes suggested in the Access help files worked. The form property "RecordsetType" needed to be set to Dynaset(Inconsistent Updates). Once this was done, selecting from the dropdowns worked perfectly, just as I wanted it to.
Thanks Craig

 

[RuralGuy]

Glad I could help Craig.