Combo box dilema

[MattP]

Hi,

I am trying to develop a form with a combo box. The combo
box row source is to be a query selecting a list of
materials from the 'materials' table. This is all fine so
far. But I hit trouble when I try to set the control
source for the combo box to a different field in a
different table - 'material' in the 'quote details' table.
When operating the form, the combo box will drop down a
list of all the materials availiable from the row source
(all good) but when I try to select one, I am not allowed
to. The computer beeps and the message in the status bar
is: "This Recordset is not updatable". Now, as far as I
can tell, everything is updatable, visible and of matching
type. Has anyone got any ideas on what I could be doing
wrong here?

Thanks heaps,
Matt.

 

[John Vinson]

The computer beeps and the message in the status bar
is: "This Recordset is not updatable".

The problem is almost certainly in the Form's Recordsource, not
anything directly to do with the combo. Try opening the Form in design
mode, view its Recordsource property, and click the ... icon to open
it in query design view; then view that query as a Datasheet. Does it
let you modify data or add records?

If not, what is the SQL view of the query? Does it involve any Sum or
Avg or Group clauses (all death to updatability), or a table join
(which can still be updatable if done right)?

 

[jamie considine]

is your recordsource for the for a query from multiple
tables? if so, you may have to set the unique table
property to tell the system which table gets updated
during a record edit.

Jamie