Drop down lists and populating fields

[KarenF]

Hi,

We have a combo box picking data from one table for input into another by
means of a form. We would like another field to self-populate with
corresponding data in the table which is the source for the drop-down list,
depending on what is picked from the drop down list.

We've tried creating forms from queries with both tables in, and using the
form wizard to create a form taking fields from both tables, but we're stuck.
As soon as we create a form from either the query or from the two tables, we
are unable to input anything. The tables are related on a 1:many basis.

Any help would be gratefully received.

Many thanks,

Karen

 

[jahoobob via AccessMonster.com]

Some multi-table queries require that you set the forms Recordset type to
Dynaset (Inconsistent Updates).

 

[Klatuu]

Not all recordsets are updateable, particularly when you have a one to many
relationship.
In a case like this, you should consider a form/subform construct. Make the
one side the record source for the form and the many side the record source
for the subform.